Permanently Attach Custom Toolbar?

[Guest]

I've been writing quite a few macros and attaching them to buttons on my own
Excel. However, how would you permanently attach your own toolbar to other
people's Excel without having each of the end-users go through the trouble of
creating the button (some of these buttons have custom-drawn images) and
attaching the macro?
To be more specific, I guess I was hoping to have something that functions
like the PERSONAL.xls workbook that would be open, but hidden, every time the
user starts Excel.

Thanks for the guidance.

 

[Chip Pearson]

The best way might be to create an add-in that builds the command bars and
menu items on the fly when it is opened. Then, all you need to do is
distribute the XLA file. See http://www.cpearson.com/Excel/CreateAddIn.htm
for the basics of creating an add-in.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Dave Peterson]

Some more links:

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)

 

[GeoffreyBarnard]

Anony

Did you ever sort your problem?
GeoffreyBarnard