Thank you for your help - I just noticed that it was saved to "Personal.xls"
Karen

"Tom Ogilvy" wrote:

Using Alt+F11 is the way to go. However, in Tools=Macro=macros, if the
macro is in the activeworkbook, it will only show the macro name. If it is in
another workbook (such as a hidden workbook), it will show the Workbook Name
as well

ex:

Personal.xls!MyMacro

--
Regards,
Tom Ogilvy


"Karen" wrote:

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!