View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Rey Dave Rey is offline
external usenet poster
 
Posts: 1
Default Creation of "floating" toolbar

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