New Menu/ toolbar distribution

[Guest]

I created a new menu & toolbar with some macros attached to them..(to do some particular task) . Now i want to distribute it to couple of users. I know one way is to do it manually....but i was wondering if there could be some other automated way to achieve the same goal.

Suggestions will be appreciated

Thanks
Ajit

 

[pauluk]

I would like to see the how you have created the new menu\tool bar i
there permittly or just when the sheet is open?

You can distriubte the add-in by creating a com file i think, or creat
a personal sheet whcih contains the code to run.

You can add an auto open function that will then automactally start th
toolbar macro or even set that as the auto open