I like to either add an option to one of the toolbars or even create a dedicated
toolbar that would allow the user easy access to the macro.

For additions to the worksheet menu bar, 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)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl
or
http://www.rondebruin.nl/ribbon.htm

Kevin wrote:

Hi, this is actually a question from a friend that I couldn't answer. She
works at a school with a proprietary program that does attendance. Several
times each day she exports a list to excel, but needs most of the columns
deleted and one added. I made her a macro to do this and it works fine. The
problem is, after the initial run, the workbook containing the macro is
minimized and she then exports another list, but the macro won't run again
unless she reopens the workbook containing the macro. She also said there is
no personal.xls listing when looking under macros. I'm thinking this may be
the problem. Is there a way we can call up the macro from the other workbook
in a convenient way? The other program opens a new instance of excel each
time you export a list, also...hope I explained correctly. Thanks for any
help, -Kevin

--

Dave Peterson