password

[john tempest]

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

[Jim Rech]

Hover your mouse pointer over the word "Protect" and press F1.

--
Jim
"john tempest" <[email protected]> wrote in message
news:[email protected]...
| 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

[Henrich]

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

[john tempest]

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