Dear Experts,
I have 75 sheets in a workbook. All these sheets are protected with the Same Password. Is there any code to un-protect all the worksheets at the same time and another code to protect all these sheets at the same time.
I am using Windows 98 and Office 2000.
Thanks for all your efforts..
Regards,
Shan
P.S. I am sorry if this topic is discussed earlier, could not find it during my search.
I have 75 sheets in a workbook. All these sheets are protected with the Same Password. Is there any code to un-protect all the worksheets at the same time and another code to protect all these sheets at the same time.
I am using Windows 98 and Office 2000.
Thanks for all your efforts..
Regards,
Shan
P.S. I am sorry if this topic is discussed earlier, could not find it during my search.