A1VBCode Forums

VBA Excel Convert the excel file into readonly by codes...


http://a1vbcode.com/vbforums/Topic26903.aspx

By Krishal Rajput - 1/29/2009

Hello...... I am working on SQL Server 2000. I have a database that has almost 150 tables. I need to develop a report in excel. For this purpose i need to fetch data from my database and display the same in excel.



After doing this i need to ensure that no one can edit the data that i have fetched. So somehow i need to lock the grid of the excel sheet in which i have displayed the report result. Cant do this........What to do?
By zlatan24 - 11/10/2010

Krishal Rajput (1/29/2009)
Hello...... I am working on SQL Server 2000. I have a database that has almost 150 tables. I need to develop a report in excel. For this purpose i need to fetch data from my database and display the same in excel.



After doing this i need to ensure that no one can edit the data that i have fetched. So somehow i need to lock the grid of the excel sheet in which i have displayed the report result. Cant do this........What to do?




My father had an unpleasant issue with excel document. I advised him a tool, which to my surprise aided him quickly. Above it he thanked me a lot and I believe that such tool might be curious for solving similar propositions - how to recovery corrupted Excel file.