Creation of "floating" toolbar

[Dave Rey]

Hi
I currently have a workbook that contains many different
worksheet (around 40).
At the moment each sheet is accessed via a hyperlink from
the main menu (on the 1st sheet). On each sheet there is
another hyperlink to return back to the main menu.

What I was wanting to do was create a "floating toolbar"
with a button which can link back to the main menu. I am
not very good at VBasic and don't know where to start.

Ideally the toolbar (or form) should open automatically
when the file is opened, and remain on the screen at all
times (it would also be good if it could be moved around
the screen). I could then add different buttons to the
toolbar to perform different functions (ie return to main
menu, save, close etc).

Also, is it possible to add some sort of code to a file,
so that whenever it is closed it automatically returns to
the main menu, saves,and then closes, so each time it is
reopened it is at the main menu??

Many thanks in advance

Dave Rey

 

[Tom Ogilvy]

go to tools=>customize and in the dialog, there is a button to add a
toolbar. You can then customize it and attach it to your workbook.

here is some reference material:


The best way to do this is to create your custom menus with a macro in the
Workbook_Open event and delete them in the Workbook_BeforeClose event. This
way you are sure you have full control over the menus and that they are
pointing to the right code when they execute.

An alternate way is to use the Attach command in the the Tools=>Customize
dialog in the Toolbars tab. This way, when your file is opened, if the
toolbar does not exist, it is created from the toolbar attached to the file.
It is still a good idea to remove the toolbar when you close the workbook by
using the Workbook_BeforeClose event.

Here is an article which talks about attaching toolbars:

http://www.microsoft.com/exceldev/articles/toolbatt.htm

Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

Here is another article or two you might find useful:
http://msdn.microsoft.com/library/backgrnd/html/msdn_addins97.htm
http://msdn.microsoft.com/library/officedev/odeopg/deovrcreatingexceladdin.htm
http://www.microsoft.com/exceldev/tips/addins.htm
These are about distributing applications

http://support.microsoft.com/?id=159619
XL97: Sample Macros for Customizing Menus and Submenus

http://support.microsoft.com/?id=213550
XL2000: Sample Macros for Customizing Menus and Submenus


http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw
How to customize menus and menu bars in Excel

http://support.microsoft.com/default.aspx?scid=kb;en-us;166755
File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R)
Excel 97
File Name: WE1183.EXE
File Size: 58041 bytes
File Date: 06/20/97
Keywords: kbfile kbappnote
Description: This Application Note can help you learn techniques for writing
Visual Basic(R) for Applications code to customize menus in Microsoft Excel
97. This Application Note contains code examples that you can use with the
following elements: menu bars, menus, menu items, submenus, and shortcut
menus.