A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

excel custom menu



 
 
Thread Tools Display Modes
  #1  
Old September 15th, 2003, 01:27 AM
Lynn
external usenet poster
 
Posts: n/a
Default excel custom menu

Thank you!
A problem is that when a user click on a chart in the
workbook, the menu is no longer showing on the
commmandbar. Until user clicks somewhere else other than
the chart, the menu is back.

Any idea?

-----Original Message-----
This file might be a help:
http://www.bygsoftware.com/examples/.../MenuActiveWbD

emo.zip

It's in the "Menu Routines" section on page:
http://www.bygsoftware.com/examples/examples.htm

It contains VBA code that will activate a menu only when

the workbook it is
in is active.
The code is open and commented.

All you have to do is substitute your own routine names

for those in the
demo.

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",

http://www.bygsoftware.com/saveandbackup.htm
"The Excel Auditor" and "Byg Tools for VBA"


"Lynn" wrote in message
...
Hi anyone,
I create an excel file, named measure.xls with custom

menu
called pace. A few simple drop-down menu bar were
assigned to this pace menu. Each menu bar is assigned

to
an macro such as view a selected chart. Save

measure.xls
to c:\ drive. Test, it works fine. I save this excel
file to another drive such as d:, my menu in the new

excel
worksheet stops working, it said worksheet is already
open. I check each menu bar in this excel file (in d:
drive), it seems that the macros are assigned to
c:\measure.xls worksheet macro.

How can I make it work? How can I create a menu in a
worksheet and then save it to a different location and

the
menu is still working?

Can someone help me? I appreciate.
Lynn



.

  #2  
Old September 15th, 2003, 01:31 AM
Lynn
external usenet poster
 
Posts: n/a
Default excel custom menu

Bob,
Thanks! I built the menu using these code
Set MenuObject = Application.CommandBars(1). _
Controls.Add(Type:=msoControlPopup, _
Befo=PositionOrMacro, _
Temporary:=False)

It is showing fine until I click on a chart in the
worksheet and the menu is not longer showing. If I click
somewhere else, the menu is back.
Any idea?

-----Original Message-----
Lynn,

Why don't you assign the menu controls to the macros in

the workbook open
event code, or even build the menu in there, so that it

dynamically changes
with the worksheet?

--

HTH

Bob Phillips

"Lynn" wrote in message
...
Hi anyone,
I create an excel file, named measure.xls with custom

menu
called pace. A few simple drop-down menu bar were
assigned to this pace menu. Each menu bar is assigned

to
an macro such as view a selected chart. Save

measure.xls
to c:\ drive. Test, it works fine. I save this excel
file to another drive such as d:, my menu in the new

excel
worksheet stops working, it said worksheet is already
open. I check each menu bar in this excel file (in d:
drive), it seems that the macros are assigned to
c:\measure.xls worksheet macro.

How can I make it work? How can I create a menu in a
worksheet and then save it to a different location and

the
menu is still working?

Can someone help me? I appreciate.
Lynn



.

  #3  
Old September 15th, 2003, 10:16 AM
Andy Wiggins
external usenet poster
 
Posts: n/a
Default excel custom menu

The code adds the menu to the "Worksheet Menu Bar". When a chart is active
the "Worksheet Menu Bar" is replaced by the "Chart Menu Bar". You will have
to adapt the code to suit this condition.

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"


"Lynn" wrote in message
...
Thank you!
A problem is that when a user click on a chart in the
workbook, the menu is no longer showing on the
commmandbar. Until user clicks somewhere else other than
the chart, the menu is back.

Any idea?

-----Original Message-----
This file might be a help:
http://www.bygsoftware.com/examples/.../MenuActiveWbD

emo.zip

It's in the "Menu Routines" section on page:
http://www.bygsoftware.com/examples/examples.htm

It contains VBA code that will activate a menu only when

the workbook it is
in is active.
The code is open and commented.

All you have to do is substitute your own routine names

for those in the
demo.

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",

http://www.bygsoftware.com/saveandbackup.htm
"The Excel Auditor" and "Byg Tools for VBA"


"Lynn" wrote in message
...
Hi anyone,
I create an excel file, named measure.xls with custom

menu
called pace. A few simple drop-down menu bar were
assigned to this pace menu. Each menu bar is assigned

to
an macro such as view a selected chart. Save

measure.xls
to c:\ drive. Test, it works fine. I save this excel
file to another drive such as d:, my menu in the new

excel
worksheet stops working, it said worksheet is already
open. I check each menu bar in this excel file (in d:
drive), it seems that the macros are assigned to
c:\measure.xls worksheet macro.

How can I make it work? How can I create a menu in a
worksheet and then save it to a different location and

the
menu is still working?

Can someone help me? I appreciate.
Lynn



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:17 AM.


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