| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Unprotect save worksheet and protect it again.
Activesheet.Unprotect Password:="ABC"
Range("B6:O6").Locked = False Activesheet.Protect Password:="ABC" Activesheet.Unprotect Password:="ABC" Range("B6:O6").Locked = True Activesheet.Protect Password:="ABC" -- Regards, Tom Ogilvy "holy41" wrote: I need a macro to unprotect cells B6:O6 and protect them back. I would appreciate your help . Thank Ken Calhoun |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect/ unprotect worksheet | Excel Discussion (Misc queries) | |||
| How do I unprotect a protected worksheet that has passwrod protect | Excel Discussion (Misc queries) | |||
| protect/unprotect worksheet | Excel Programming | |||
| Protect/Unprotect Worksheet | Excel Discussion (Misc queries) | |||
| Excel VBA - Problems using Protect/Unprotect a worksheet | Excel Programming | |||
Threaded Mode
