floating toolbar

[Guest]

Hi all,

is it possible to have a floating toolbar on a certain page in excel?
bascially what i want is to combine 4 sheets into one and have the same
buttons available to the user wherever they scroll on the page - but only on
that page, not for all pages.

tia!

J

 

[Jim Rech]

When you say "page" I assume you mean worksheet. To have a toolbar appear
and disappear when a worksheet is activated/deactivated you'd have to use
the corresponding events. Right click on the worksheet's tab and pick View
Code. Paste this in and change the toolbar name to yours. This will take
some fine-tuning. For instance it will not fire when the user changes to
another workbook, just to another worksheet in this workbook. So you'd also
have to code for the workbook activate/deactive events in the ThisWorkbook
module.

Private Sub Worksheet_Activate()
Application.CommandBars("myBar1").Visible = True
End Sub

Private Sub Worksheet_Deactivate()
Application.CommandBars("myBar1").Visible = False
End Sub


--
Jim
| Hi all,
|
| is it possible to have a floating toolbar on a certain page in excel?
| bascially what i want is to combine 4 sheets into one and have the same
| buttons available to the user wherever they scroll on the page - but only
on
| that page, not for all pages.
|
| tia!
|
| J

 

[Guest]

Thanks Jim!

J