Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Morning all.
I just received an error while trying to run a macro. While this is the first time I've operated on this workbook, I did check the information that the error message provided and it doesn't appear to apply on this file. Here is the message I received: ------------------------------------- run time error 1004 you cannot use this command on a protected sheet. to use this command, you must first unprotect the sheet ( review tab, changes group, unprotect sheet button). you may be prompted for a password. ------------------------------------- I went to the review tab, looked at the changes group, and there is no "unprotect" option. I then clicked on the protect workbook icon, and it says unrestricted access. I then tried clicking on that, and nothing changes-- as it's already checked. Any ideas on how to resolve this? So far I've been able to run other macros with no trouble, so I'm a little stuck/confused here. Your helps are deeply appreciated. The macro that I'm running is one that I obtained from Thomlinson. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
400 Error in Unprotect/Protect Macro | Excel Discussion (Misc queries) | |||
Error 1004 in Excel 97 when trying to unprotect a worksheet | Excel Programming | |||
unprotect VBA error | Excel Programming | |||
Unprotect worksheet error | Excel Programming | |||
Unprotect method run-time error | Excel Programming |