View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
tomhaddock tomhaddock is offline
external usenet poster
 
Posts: 1
Default Floating control box

Hi

I have a floating control box solution.

Go to Visual Basic Editor and create a UserForm and a button on it for
each Sheet. (Lets name the UserForm frmSelectSheet)
In each button's OnClick Event type in:

Worksheets("SheetName").Activate

or if it a Chart sheet substitute 'Worksheets' with 'Charts'

Then double-click on 'ThisWorkBook' and select its OnOpen Event and
type in:

Load frmSelectSheet

That's it!

Tom