View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default Macro Error Message

Karen,
By "Hidden", Excel is refering to the workbook's state inside Excel.
This is not connected with the Hidden attribute you can set say throught
ExplorerRight clickProperties.

NickHK

"Karen" ...
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!