ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ActiveSheet.Protect (https://www.excelbanter.com/excel-programming/311546-activesheet-protect.html)

Żaczek

ActiveSheet.Protect
 
Hello,

I`ve written :

ActiveSheet.Protect
(without anu parameters)

and now, when I try :

ActiveSheet.Unprotect

Excel is asking me for password! Why? How can I unlock my Sheet now?

Thank you for your help !!



rog

ActiveSheet.Protect
 
The code worked fine on my Excel 97 machine...

maybe just try :

activesheet.unprotect vbnullstring

Rgds

Rog



-----Original Message-----
Hello,

I`ve written :

ActiveSheet.Protect
(without anu parameters)

and now, when I try :

ActiveSheet.Unprotect

Excel is asking me for password! Why? How can I unlock my

Sheet now?

Thank you for your help !!


.



All times are GMT +1. The time now is 12:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com