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
|