I wouldn't attach the toolbar to the workbook.
I'd build the toolbar on the fly.
Here's how I do it:
http://groups.google.co.uk/groups?th...5B41%40msn.com
If you want to add items to the worksheet menu bar, you can use John
Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm
Elsa wrote:
I have a toolbar attached to my workbook and all the macros are saved in this
particular workbook. When I open this document on another computer it
prompts for the old path. I then have to sit and re-assign each of the
macros to the toolbar.
Is there a way of preventing this?
Help will be much appreciated
--
Dave Peterson