LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Why does this mouse menu call a sub from another workbook?

Hello,

I've been on this problem for more than a day now and I can't figure it
out.
I have a worksheet embedded chart which, on right click, shows a
modified mouse menu, which in turn allows to fire a sub called
"MaakGraf". Like this

Set MenuItem =
Application.CommandBars("Object/plot").Controls.Add(Type:=msoControlButton)
With MenuItem
.Caption = "Maak deze Grafiek"
.OnAction = "MaakGraf"
End With

It worked perfectly until yesterday. But since then, when clicking the
"Maak deze Grafiek" option, I get a prompt to enable or disable the
macro's of an OTHER workbook, to wich there is absolutely no link
although this other workbook is very similar to the active one and has
a sub with the same name. If enabled, the other workbook is opened.

If called with F5 or via the Extra-Macro menu, the sub perfectly refers
to the intended sub in the active workbook.

What am I overlooking here ?

Thank you very much for any help.
Herman

 
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
Mouse shortcut menu SueK Excel Discussion (Misc queries) 0 October 28th 09 03:10 PM
Call Macro using right click menu Ivan Excel Programming 3 May 4th 06 02:29 AM
modify mouse menu Richard U Excel Discussion (Misc queries) 1 April 1st 05 01:56 AM
Adding menu to the mouse right click pop-up menu Jack Excel Programming 1 February 12th 04 05:23 AM
Send menu call to explicit Sub Stuart[_5_] Excel Programming 6 September 29th 03 12:44 AM


All times are GMT +1. The time now is 10:38 PM.

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

About Us

"It's about Microsoft Excel"