Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet protection
I have a workbook with 12 sheets. What I would like to do is protect all 12
with a password of "Popcorn", without having to select each sheet. Then I would like to do the reverse of unprotecting them without having to select them. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet protection
You could add two routines to your workbook: sub protect_all_sheets() for each w in thisworkbook.worksheets w.protect password:="Popcorn" next end sub sub unprotect_all_sheets() for each w in thisworkbook.worksheets w.unprotect password:="Popcorn" next end sub Col -- colofnature ------------------------------------------------------------------------ colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356 View this thread: http://www.excelforum.com/showthread...hreadid=547518 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Worksheet Protection | Excel Discussion (Misc queries) | |||
worksheet protection | Excel Discussion (Misc queries) | |||
worksheet protection | Excel Programming |