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.

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

On Sun, 10 Aug 2008 19:55:00 -0700, leungkong
wrote:

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.

Thanks Gord,
you are a Genius


"Gord Dibben" wrote:

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

On Sun, 10 Aug 2008 19:55:00 -0700, leungkong
wrote:

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.