Macro Error Message
Thank you for your help - Each one was empty
Karen
"John" wrote:
Try Alt+F11 to open the VBE ("code editor") and have a look at the project
tree on the left hand side. You should be able to double-click each node in
the tree (unless its protected) to reveal the code behind. I assume most
will be empty, but you might find it that way.
Hope that helps
Best regards
John
"Karen" wrote in 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!
|