Create it at workbook open, and delete on work book close, end of problem.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Simon Lloyd " wrote in message
...
Why when moving a worlbook do i have to re-assign the macro's to the
buttons whish were already assigned...its becoming a pain moving the
work book to another pc after updating or something....and sometimes
the custom tool bars appear at the bottom of the screen in xp....the
book was created in xp and being saved down to excel 97 cos my
workplace mostly has this and only a few xp

Can anyone solve this?

Simon


---
Message posted from http://www.ExcelForum.com/