Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add a macro to a custom menu?
I can't find my macros in the customize/commands list
|
#2
|
|||
|
|||
How do I add a macro to a custom menu?
Where did you store them? They should be in a standard code module. If the
module has Option Private Module at the head, the macros are declared as private, or they have arguments, you will not see them. -- HTH RP (remove nothere from the email address if mailing direct) "MikeCyng" wrote in message ... I can't find my macros in the customize/commands list |
#3
|
|||
|
|||
How do I add a macro to a custom menu?
Thanks for your response Bob.
They are in a module in the VB editor. I can't see 'Option Private' in the module and there are no argumants. I can assign the macro to a button but can't get them as items in a drop down menu. Cheers Mike "Bob Phillips" wrote: Where did you store them? They should be in a standard code module. If the module has Option Private Module at the head, the macros are declared as private, or they have arguments, you will not see them. -- HTH RP (remove nothere from the email address if mailing direct) "MikeCyng" wrote in message ... I can't find my macros in the customize/commands list |
#4
|
|||
|
|||
How do I add a macro to a custom menu?
Are you saying that you have added a dropdown tom a commandbar, and you want
to add your macros to it? -- HTH RP (remove nothere from the email address if mailing direct) "MikeCyng" wrote in message ... Thanks for your response Bob. They are in a module in the VB editor. I can't see 'Option Private' in the module and there are no argumants. I can assign the macro to a button but can't get them as items in a drop down menu. Cheers Mike "Bob Phillips" wrote: Where did you store them? They should be in a standard code module. If the module has Option Private Module at the head, the macros are declared as private, or they have arguments, you will not see them. -- HTH RP (remove nothere from the email address if mailing direct) "MikeCyng" wrote in message ... I can't find my macros in the customize/commands list |
#5
|
|||
|
|||
How do I add a macro to a custom menu?
Yes, I've added a 'New Menu' to the toolbar and I want to add macros as items
in the drop down menu. "Bob Phillips" wrote: Are you saying that you have added a dropdown tom a commandbar, and you want to add your macros to it? -- HTH RP (remove nothere from the email address if mailing direct) "MikeCyng" wrote in message ... Thanks for your response Bob. They are in a module in the VB editor. I can't see 'Option Private' in the module and there are no argumants. I can assign the macro to a button but can't get them as items in a drop down menu. Cheers Mike "Bob Phillips" wrote: Where did you store them? They should be in a standard code module. If the module has Option Private Module at the head, the macros are declared as private, or they have arguments, you will not see them. -- HTH RP (remove nothere from the email address if mailing direct) "MikeCyng" wrote in message ... I can't find my macros in the customize/commands list |
#6
|
|||
|
|||
How do I add a macro to a custom menu?
I've finally managed to find a website which answers my question -
http://www.aicpa.org/pubs/jofa/jul2001/lenning.htm I can see were i was going wrong now! Thanks for taking the trouble to reply. Cheers Mike "Bob Phillips" wrote: Are you saying that you have added a dropdown tom a commandbar, and you want to add your macros to it? -- HTH RP (remove nothere from the email address if mailing direct) "MikeCyng" wrote in message ... Thanks for your response Bob. They are in a module in the VB editor. I can't see 'Option Private' in the module and there are no argumants. I can assign the macro to a button but can't get them as items in a drop down menu. Cheers Mike "Bob Phillips" wrote: Where did you store them? They should be in a standard code module. If the module has Option Private Module at the head, the macros are declared as private, or they have arguments, you will not see them. -- HTH RP (remove nothere from the email address if mailing direct) "MikeCyng" wrote in message ... I can't find my macros in the customize/commands list |
#7
|
|||
|
|||
How do I add a macro to a custom menu?
I really like the way John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm MikeCyng wrote: I can't find my macros in the customize/commands list -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Remove custom menu | Excel Discussion (Misc queries) | |||
Editing XL95 custom menus with XL97 | Excel Worksheet Functions | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |