PDA

View Full Version : Solved: Create Custom Menu Macro Items in Excel VBA



sasa
01-24-2010, 10:05 AM
Pls, someone can help me to create a custom Macro items. I have a lot of macro and everytime I have to do a lot of work (open windows, close windows an so on) to run my macro.
Thanks

sasa

lucas
01-24-2010, 10:40 AM
What version of Excel?

Bob Phillips
01-24-2010, 10:49 AM
Pls, someone can help me to create a custom Macro items. I have a lot of macro and everytime I have to do a lot of work (open windows, close windows an so on) to run my macro.

Why, what do the macros do?

sasa
01-26-2010, 01:08 AM
Excel 2007. What I need is a customizable menu where I can add the items of my macros, the way I can run these from there. Thats all. Can someone help me ?

Bob Phillips
01-26-2010, 01:50 AM
Show the Developer tab, Office Button>Excel Options>Popular and tick the 'Show Developer Tab in the Ribbon', which has buttons to ru macros amongst other things.