Pull Down Menu Macro
 

I am looking for a macro to run from the menu.

I need the menu macro to support running two macros separately.

Like

-Run Macro
- Sub (Run Macro 1)
- Sub (Run Macro 2)

Please help

--
ciba123
-----------------------------------------------------------------------
ciba1234's Profile: http://www.excelforum.com/member.php...fo&userid=2729
View this thread: http://www.excelforum.com/showthread.php?threadid=46998

Pull Down Menu Macro
 

Hi .....,
You will need a third macro

Sub Macro3()
Application.Run "personal.xls!Macro1"
Application.Run "personal.xls!Macro2"
End Sub

more information in
http://www.mvps.org/dmcritchie/excel/install.htm

I don't think your question involved how to add a menu item but if
I'm mistaken see
http://www.mvps.org/dmcritchie/excel/toolbars.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ciba1234" wrote in message
...

I am looking for a macro to run from the menu.

I need the menu macro to support running two macros separately.

Like

-Run Macro
- Sub (Run Macro 1)
- Sub (Run Macro 2)