Excel Work Sheet Protect
 

Hi

Can anyone help. Is there code to protect a worksheet using the Version
of VBA that comes along with Office/Excel 97. I understand that with
later versions the follwing would work.

Sheets("Sheet1").Protect password:="anything"

but is there something similar in 97 Version.


Regards Kev


*** Sent via Developersdex http://www.developersdex.com ***

Excel Work Sheet Protect
 

The same code works in 97 too.

Regards,
Shah Shailesh
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

*** Sent via Developersdex http://www.developersdex.com ***

Excel Work Sheet Protect
 

Hi
thanks for your reply, doesent work in the copy that I have.

Returns a Run-time error 1004, Protection class failed.

regards Kev


*** Sent via Developersdex http://www.developersdex.com ***