Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error 1004 "Cannot edit a macro ..."
I've written an addin that from workbook_open calls an
addmenu sub that builds a custom menu. The addmenu sub has the line Application.MacroOptions Macro:="GICreateToolbar", HasShortcutKey:=True, ShortcutKey:="t" This line causes a problem when you start Excel by double clicking a file containing a macro. You get the error "Runtime error 1004 Cannot edit a macro on a hidden workbook. Unhide the workbook using the unhide command" How do I avoid this error without having to remove my shortcut? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Reference not valid" error when I try to edit the macro in excel | Excel Discussion (Misc queries) | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
"Run Time Error 1004 Application Defined or Object Defined Error." | Excel Programming | |||
"Run-time error '1004'" Method 'Range' of object '_global' failed. | Excel Programming |