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

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

--
Jim
"john tempest" <johntempest@discussions.microsoft.com> wrote in message
news:F66291F9-3EBF-46A0-A8A6-2E0D5781DD53@microsoft.com...
| 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

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

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