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