ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   disabling readonly(protect on worksheet) using vba (https://www.excelbanter.com/excel-programming/363064-disabling-readonly-protect-worksheet-using-vba.html)

tweety127[_13_]

disabling readonly(protect on worksheet) using vba
 

hi experts...
is it possible to disable the protection of the worksheet, using vba
codes? how? thanks....


--
tweety127
------------------------------------------------------------------------
tweety127's Profile: http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=547637


Jeff Standen[_2_]

disabling readonly(protect on worksheet) using vba
 
Your best bet when you want to find something like this is to use the macro
recorder. There are a number of options when locking and unlocking so I
would suggest you do that so you get the right code.

Jeff

"tweety127" wrote in
message ...

hi experts...
is it possible to disable the protection of the worksheet, using vba
codes? how? thanks....


--
tweety127
------------------------------------------------------------------------
tweety127's Profile:
http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=547637





All times are GMT +1. The time now is 03:24 AM.

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