Organize Macros

[Guest]

Where is the organize dialogue box for Excel Macros? I found it once, but
can't find it again. I created macros for a spreadsheet, organized them so
that they were attached to the spreadsheet and then sent it to someone else
to test. The macros worked fine and they liked the concept. I then created
the other 40 macros that needed to be created, but now I can't attach them
because I can't find Organize. Please help!

~C

 

[Dave Peterson]

I think you found Organize in MSWord.

You can attach macros to toolbar icons via tools|customize|toolbars tab|Attach

But if you're going to invest time in creating your toolbar, you may want to try
this instead.

I really like the way John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)