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