Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Reference not valid" error when I try to edit the macro in excel Yuvaraj Excel Discussion (Misc queries) 1 January 10th 08 08:32 PM
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F daves Excel Discussion (Misc queries) 3 April 24th 07 04:52 AM
Run-time error "1004" Select method of range class failed Tallan Excel Discussion (Misc queries) 3 March 7th 07 05:22 PM
"Run Time Error 1004 Application Defined or Object Defined Error." BJC Excel Programming 4 October 26th 03 03:09 AM
"Run-time error '1004'" Method 'Range' of object '_global' failed. haisat[_2_] Excel Programming 0 October 20th 03 12:13 PM


All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"