Skip to Content
0
Former Member
Apr 09, 2009 at 11:34 AM

Workbook Password

162 Views

Hi All,

I need to have password protected for my Workbooks .I opened the WB. and then in >WB settings,

checked on Pwd Protected, and gave a Pwd...Now on the WB, if i click on Chart, Filter, or Information, it gives a POP UP as Protected WorkSheet The sheet is Unavailable

But i want this password pop up to be asked in the following:

1) When i am saving the WB to a view.

2) When i close the WB and open it later,, i shud nt be able to change or save anything

3) I have to set the password to all the workbooks,

Please suggest what is to be done..

Thanks and Regards