Freezing the coloumns in Excel

Closed
asdf - 29 Jan 2009 à 05:43
 asdf - 29 Jan 2009 à 07:02
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
Related:

2 responses

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

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