Worksheet protection problem

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?
--
Joe

VBA Automation/VB/C++/Web and DB development

Never mind. I figured it out.

"Joe" wrote:

> 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?
> --
> Joe
>
> VBA Automation/VB/C++/Web and DB development