Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Error Message
I posted this message a few weeks ago. I wasn't sure if I added a reply to
the old message if it would get "buried." So, I started a new one. I recorded a macro over one year ago for a workbook that consists of many worksheets. I have to edit the macro - I went to Tools Macro Macros Edit and I get the following error message. "Cannot edit a macro on a hidden workbook. Unhide the workbook using the Unhide command." This workbook is not hidden. What else could be happening and how do you fix this problem? Finny suggested: Try hiding it. Then unhiding it. That's all I've got right now. SyrNO said: Is it possible that you saved the macros in a module in Personal.xls? It is typically a "hidden" workbook, but because it's open, the macros are always available. I went to the file properties and checked the hidden attribute and then unchecked it again and that didn't work. Is there another way to do this? How do I find out whether or not I saved the macros in a module in Personal.xls? HELP! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro error message | Excel Programming | |||
Macro Error message | Excel Programming | |||
Macro Error Message | Excel Programming | |||
Macro Error Message | Excel Programming |