Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect and unprotect
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect and unprotect
Jackpot!
2 sheets had different passwords Many thanks Andrew "Andrew" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect, unprotect | Excel Discussion (Misc queries) | |||
Protect / unprotect function | Excel Worksheet Functions | |||
protect/unprotect a VBA Project | Excel Programming | |||
Protect/unprotect worksheets | Excel Programming | |||
Unprotect and protect.... | Excel Programming |