How to assign macros to custom buttons with another macro 2

[Jean01]

Hello,
I have a spreadsheet that serves the purpose of a schedule. With this, I have created a custom toolbar that contains buttons used to run macros that will modify the format of the cells (a.k.a. days) and apply different shadings to the selected cell. This toolbar was distributed with an *.XLB file that was openned at one point.
Comes the period of the year where a new version of the schedule is released to everyone and they all have to manually reassign the new macros to the toolbar.

Is there a way to programatically re-assign macros from the new workbook to the buttons already in place?

Any help appreciated

 

[Dreamboat]

Jean, can't help you specifically. However, here are my favorite Excel reference sites--bookmark 'em. We have some really terrific programmers right here too!

http://j-walk.com/ss/excel/tips/index.htm

http://www.erlandsendata.no/english/downloads/index.htm

http://www.excel-vba-access.com/jobs-excel-vba.htm

http://www.cpearson.com/excel/topic.htm

http://www.PiersonTech.com

dreamboat@nni.com
Brainbench MVP for Microsoft Word

 

[Jean01]

Dreamboat,
I was able to find my answers here:

http://www.erlandsendata.no/english/downloads/index.htm

I really appreciate it.
Thank you very much

Jean

 

[Dreamboat]

I thought I had seen something like you needed in one of them, Jean, but didn't have the time earlier today to find the exact one. For some reason, I thought you said you were new-ish to Excel VBA. For both of these reasons, I posted the links. I constantly refer to them to steal code. I hope to (sometime in the near future) have a similar Word site. Already "bought" the domain name TheWordExpert.com

http://www.PiersonTech.com

dreamboat@nni.com
Brainbench MVP for Microsoft Word