Freezing the coloumns in Excel

asdf - Jan 29, 2009 at 05:43 AM
 asdf - Jan 29, 2009 at 07:02 AM
i have some particular values in excel sheet.
those values in the excel sheet should not be modified after a period
so tell me how can i protect those coloumns using macros

2 replies

Sandira Posts 6 Registration date Sunday February 24, 2008 Status Member Last seen June 1, 2009
Jan 29, 2009 at 06:03 AM

I dont know how you can do that in macros because when i have tried it you can still modify the values entered. What I would suggest you then is to try to use the "Protect Sheet" or "Protect Workbook" features and for a full security, save the excel sheet as a Read Only format.
I have to protect only some coloumns