Sending Personal.xls Files To Multiple Users

[Chuckles123]

I saved my workbook file containing macros as an .xla file to a share
drive on our network. Now, when I open a workbook, and click-o
Tools>Add-Ins, I see the name of the .xla file (w/o extension) and
'check-mark' adjacent to it.

Now what do I do? I would like to link one of the macros in the .xl
file to a Custom Menu Button on the Standard Toolbar; but I am not abl
to do this. Thus, when a workbook is opened, the user could access th
macro by clicking on the Custom Menu Button << at least, that's m
objective.

I would appreciate a response.
Chuckles12

 

[Dave Peterson]

Most people handle this in the workbook_open event. The build the changes on
the fly--and delete the changes when excel closes their addin.

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

It's easy to update and looks really professional.