toolbars - button

[leungkong]

I have created a customize toolbars and some button.
I have assigned Macro in the button.
But I find that if i save as the workbook and rename the workbook, the bath
of macro also changed.
when i open the original workbook, i need to assign macro again.
any suggestion to me?
can i create the toolbar and assign macro when the workbook is open?
and delete the toolbar when the working close?
Thanks so much.

 

[Gord Dibben]

See Debra Dalgleish's site for creating toolbars.

http://www.contextures.on.ca/xlToolbar02.html

If you just want it for one workbook, ignore the part about saving as an
add-in.


Gord Dibben MS Excel MVP

 

[leungkong]

Thanks Gord,
you are a Genius

See Debra Dalgleish's site for creating toolbars.

http://www.contextures.on.ca/xlToolbar02.html

If you just want it for one workbook, ignore the part about saving as an
add-in.


Gord Dibben MS Excel MVP