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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Error Message
Did you try clicking on "Window/UnHide"? If you did save it to
"personal.xls" it will be listed in the box that opens. -- Best wishes, Jim "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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Error Message
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Error Message
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Error Message
Thank you for your help - I just noticed that I did save it to "personal.xls"
I went to "Window/UnHide" and now my macro disappears. Karen "Jim Jackson" wrote: Did you try clicking on "Window/UnHide"? If you did save it to "personal.xls" it will be listed in the box that opens. -- Best wishes, Jim "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! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Error Message
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! |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Error Message
Thank you Nick - That's good to know.
Karen "NickHK" wrote: 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! |
Reply |
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 |