Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi - I am either missing something really simple or something else is
happening: This works fine... sub proc i_protect Dim mySheet As Worksheet For Each mySheet In Worksheets mySheet.protect ("abc1234") Next mySheet end sub This says the password is incorrect... sub proc i_unprotect Dim mySheet As Worksheet For Each mySheet In Worksheets mySheet.Unprotect ("abc1234") Next mySheet end sub Any ideas? Thanks Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect, unprotect | Excel Discussion (Misc queries) | |||
protect and unprotect | Excel Programming | |||
Password - Protect, UnProtect | Excel Programming | |||
Unprotect and protect.... | Excel Programming | |||
Thanks Otto.......Unprotect and re-Protect | Excel Programming |