Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
password
ActiveWorkbook.Sheets("MANUAL TS").Protect
i use the above code to protect a worksheet, what extra code do i need to use a password thankyou john |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
password
Hover your mouse pointer over the word "Protect" and press F1.
-- Jim "john tempest" wrote in message ... | ActiveWorkbook.Sheets("MANUAL TS").Protect | i use the above code to protect a worksheet, what extra code do i need to | use a password | thankyou john |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
password
U don't need an extra code just add after protect Password := "drowssap"
example: ActiveWorkbook.Protect Password := "password" €žjohn tempest" napĂ*sal (napĂ*sala): ActiveWorkbook.Sheets("MANUAL TS").Protect i use the above code to protect a worksheet, what extra code do i need to use a password thankyou john |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
password
thankyou Heinrich
that works just fine "Henrich" wrote: U don't need an extra code just add after protect Password := "drowssap" example: ActiveWorkbook.Protect Password := "password" €žjohn tempest" napĂ*sal (napĂ*sala): ActiveWorkbook.Sheets("MANUAL TS").Protect i use the above code to protect a worksheet, what extra code do i need to use a password thankyou john |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to retrive password protected worksheet but forgot password? | Excel Worksheet Functions | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
Comparing password entry vs stored password - 2003 | Excel Programming | |||
Excel password but cant hide the sheets before entering password | Excel Programming |