Worksheet protection problem

G

Guest

I have an XL 2002 workbook that has several password protected worksheets.
The sheets are currently protected. When I go to Tools -> Protection, the
Unprotect worksheet option is not enabled. Also, when I execute VBA to
unprotect the worksheet, I get a 1004 error (method '~' of '~' object failed).

Does anyone have an idea why this would be true?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Controlling worksheet protection via VBA 0
Worksheet protection 2
Protect multiple selected sheets? 6
Filter a protected shared worksheet 18
Programatically filter a protected shared workbook 4
Password protection worksheet 1
Protecting worksheet. 1
Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect? 2

Top