Greetings,

I am having problems toggling the Protect mode on a spreadsheet. I ca
Protect/Unprotect from the Tools menu.

The workbook is not protected nor is it shared.

When I execute my macro I get the following error message:

Run-time error '1004':

Unprotect method of Worksheet class failed


The message occurs when I execute either of the following:

- Sheets("SheetName").Unprotect
- Worksheets("SheetName").Unprotect

The macro is executed by clicking on a button on the worksheet.

I am running Excel 97.

Thanks (TIA)
Gar

--
Message posted from http://www.ExcelForum.com