| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password Protect Worksheet
If I enter the following code, my sheet is password protected
ActiveSheet.Protect ("password") If I expand on it with either of the following, I get a code error. ActiveSheet.Protect ("password") DrawingObjects:=False ActiveSheet.Protect DrawingObjects:=False ("password") What is the correct format? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Password Protect Worksheet
ActiveSheet.Protect DrawingObjects:=False, password:="password"
-- When you lose your mind, you free your life. "r wilcox" wrote: If I enter the following code, my sheet is password protected ActiveSheet.Protect ("password") If I expand on it with either of the following, I get a code error. ActiveSheet.Protect ("password") DrawingObjects:=False ActiveSheet.Protect DrawingObjects:=False ("password") What is the correct format? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way that I can password protect a worksheet | Excel Worksheet Functions | |||
| Password Protect a Worksheet | Excel Discussion (Misc queries) | |||
| Protect a worksheet with a password | Excel Worksheet Functions | |||
| password protect worksheet | Excel Discussion (Misc queries) | |||
| How can I password protect a worksheet from being deleted | Excel Discussion (Misc queries) | |||
Linear Mode
