View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Custom Toolbar Doesn't Close

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

On Sun, 29 Jul 2007 15:26:01 -0700, Muggs
wrote:

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?