Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
password protect
I have a sheet that is password protected and is protected
against comments and scenerios but not objects. I wrote a macro that would unprotect the sheet, alter a few things, then reprotect it. Here is the code: Sheets("Time").Unprotect Password:="TimeFlash" ... then later Sheets ("Time").Protect Password:="TimeFlash" However, by default, this protects it against comments, scenerios and objects. I don't want it to protect against objects. What is the better code? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protect | Excel Worksheet Functions | |||
Password Protect | Excel Discussion (Misc queries) | |||
Password Protect | Excel Discussion (Misc queries) | |||
password protect | Excel Discussion (Misc queries) | |||
Password protect | Excel Programming |