Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco to protect / unprotect worksheet
Sub UnProtect()
ActiveSheet.UnProtect Password:="snow" Run some code to do things and when complete reprotect ActiveSheet.Protect Password:="snow" End Sub Gord Dibben MS Excel MVP On Sun, 24 Jan 2010 12:55:04 -0800, ordnance1 wrote: How can I edit the code below to enter the password snow (I use a password on the protected sheet to keep people from makeing unwanted changes) Also I need code to reprotect the worksheet at the end addining the password snow. Sub Macro1() ' ' Macro1 Macro ' ' ActiveSheet.Unprotect End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Marco to protect / unprotect worksheet | Excel Programming | |||
Protect/ unprotect worksheet | Excel Discussion (Misc queries) | |||
How do I unprotect/with password to run marco and protect | Excel Programming | |||
protect/unprotect worksheet | Excel Programming | |||
Protect/Unprotect Worksheet | Excel Discussion (Misc queries) |