Hi,
I'm trying to write code that protects the active sheet, using a password
(eg: dave)
I've tried:

ActiveSheet.Protect (dave)

and

ActiveSheet.Protect Password:=dave

Both these lines of code protect the sheet, but allow it to be unprotected
without prompting for the password

I'm using XL2000, and can't find it in the VBA help.

Regards - Dave