G
Gary Richie
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:
- 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
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:
The message occurs when I execute either of the following:Run-time error '1004':
Unprotect method of Worksheet class failed
- 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