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

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

Unfortunately, my knowledge of excel is very limited!
The toolbar, menus and macros that I have created are only needed for this
one particular spreadsheet. I don't need them to be available for anything
else. I just want to be able to open this project and, hey bingo, everything
is there ready for me to use!
It works fine on this computer, but when I try to take it to my work
computer the toolbar isn't there.
Am I doing something wrong in the save process?
Am I asking too much for a novice user?!

"Dave Peterson" wrote:

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