TOOLBAR

  • Thread starter Thread starter FLKulchar
  • Start date Start date
F

FLKulchar

When I open a new spreadsheet, there exists a toolbar at
the top of the spreadsheet.

Is it possible to save the spreadsheet with its toolbar
saved, or, ......does the SAME toolbar stay open and
remain the sames for all EXCEL spreadsheets running at
the time?

In other words, is the toolbar part of the saved
spreadsheet, or not?

Thanks,

Larry
 
The toolbars are NOT part of a spreadsheet, nor is it part of a
workbook. There is one toolbars file (.xlb) that hold all of your
toolbars and it is updated every time you close Excel.

The content of the clipboard has nothing to do with the toolbar.

There is a clipboard toolbar you can drag to you worksheet
or drag to the toolbar (docking). You can bring it up with
View, Toolbars, Clipboard
you can drag it from your spreadsheet to a docking position on the
toolbar. You can drag it out from the toolbar by grabbing the
left hand edit.

It is possible to add a toolbar to your toolbar area with programming
and to remove it with programming when finished.

A simple example to implement is John Walkenbach's
(didn't say it was easy to follow)
Custom Menus in Excel 97, Tip 53
http://www.j-walk.com/ss/excel/tips/tip53.htm


Some additional references can be found under "menus" on my xlindex.htm page.
Additional information on toolbars can be found on my toolbars.htm page

Did you ever tell us what version of Excel you have.
Help, Help About.
 
I have EXCEL 2002
-----Original Message-----
The toolbars are NOT part of a spreadsheet, nor is it part of a
workbook. There is one toolbars file (.xlb) that hold all of your
toolbars and it is updated every time you close Excel.

The content of the clipboard has nothing to do with the toolbar.

There is a clipboard toolbar you can drag to you worksheet
or drag to the toolbar (docking). You can bring it up with
View, Toolbars, Clipboard
you can drag it from your spreadsheet to a docking position on the
toolbar. You can drag it out from the toolbar by grabbing the
left hand edit.

It is possible to add a toolbar to your toolbar area with programming
and to remove it with programming when finished.

A simple example to implement is John Walkenbach's
(didn't say it was easy to follow)
Custom Menus in Excel 97, Tip 53
http://www.j-walk.com/ss/excel/tips/tip53.htm


Some additional references can be found under "menus" on my xlindex.htm page.
Additional information on toolbars can be found on my toolbars.htm page

Did you ever tell us what version of Excel you have.
Help, Help About.


"FLKulchar" <[email protected]> wrote
Click to expand...
in message news:[email protected]...
 
You must have missed: "If you've moved up to Excel 97 (or later)"


--

Regards,

Peo Sjoblom
 
Back
Top