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? |
All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com