How to put Macro's on Command line

[Carmen]

I currently built a bunch of macro's and they reside on
the worksheet, but I need to know how to put them on the
command line.

There is no room for them on the worksheet, and would
clean the spreadsheet up by moving them to the command
line.

Carmen

 

[Dave Peterson]

If you'd like to be able to run your macros from more items on the menubar, you
may want to look at the way John Walkenbach did it in his menumaker program.

http://j-walk.com/ss/excel/tips/tip53.htm

 

[Jim]

Command line? Do you mean on the toolbar or in one of the existing menus?

 

[Carmen]

Sorry about that. Yes the tool bar.

-----Original Message-----
Command line? Do you mean on the toolbar or in one of the existing menus?

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays



.

 

[Dave Peterson]

When you say the macros reside on the worksheet, what does that mean?

What version of excel are you running?

If you're running xl97 or greater and you meant that your macros were in the
VBE, you could use John Walkenbach's MenuMaker workbook to add stuff to the
menubar.

http://j-walk.com/ss/excel/tips/tip53.htm