Excel Work Sheet Protect

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kev - 24 Jan 2006 13:01 GMT

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

Reply to this Message

Shailesh Shah - 24 Jan 2006 13:21 GMT

The same code works in 97 too.

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

Reply to this Message

Kev - 24 Jan 2006 14:36 GMT

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

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

regards Kev

Reply to this Message