Custom Toolbar Doesn't Close

[Guest]

I created a custom toolbar and attached it to my spreadsheet, however, the
toolbar doesn't show automatically when I open the spreadsheet. When I show
the toolbar and then close the spreadsheet, the toolbar stays open. How can
I make this toolbar open with the spreadsheet and close with the spreadsheet?

 

[Gord Dibben]

Custom Toolbars are saved with your Excelxx.xlb file which is a global file for
Excel.

To have your toolbar open with one workbook and close with that workbook you
will have to build it "on the fly" when the workbook opens and delete it when
the workbook closes.

See Debra Dalgleish's site for creating and removing a Toolbar.

http://www.contextures.on.ca/xlToolbar02.html

If just for the one workbook, ignore the part about saving the file as an
add-in.

Just save as a regular workbook.


Gord Dibben MS Excel MVP