I think you'd be better off creating the toolbar when the workbook opens and
deleting it when the workbook closes.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

On top of that, if your macros are meant to be used with different
workbooks--not just that single workbook, you may want to separate the code from
the data. You could create an addin that just builds the toolbar and calls the
macros in that addin.

It would make it simpler to update if, er, when! the code has to change.



Min wrote:

I have created a spreadsheet with a customized toolbar and macro menus.
When I save the spreadsheet onto disk and then open it on another computer,
running the same version of excel, the toolbar hasn't been saved.
How do I save the whole thing in its entirety - spreadsheet, macros and
toolbar?
Any help would be very much appreciated.
Many thanks
Min

--

Dave Peterson