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

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

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

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