Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Floating Toolbar
Hi All
Is there a way to have a floating toolbar in say Sheet1 and one in Sheet2 with different names and they only show up in there own sheet. Thanks in Advance Dave |
#2
|
|||
|
|||
Hide it and make it visible in the worksheet_Activate event
Application.Commandbars("myBar1").Visible = True -- HTH RP (remove nothere from the email address if mailing direct) "Dave" wrote in message ... Hi All Is there a way to have a floating toolbar in say Sheet1 and one in Sheet2 with different names and they only show up in there own sheet. Thanks in Advance Dave |
#3
|
|||
|
|||
Thanks for a quick reply, Bob
I'm new to Excel, I've been looking were to put this code I've looked in the sheet, view code etc. Also looked in Help. I'm lost Could you tell me how and where to put this code. Application.Commandbars("myBar1").Visible = True ------------------------------- Hi All Is there a way to have a floating toolbar in say Sheet1 and one in Sheet2 with different names and they only show up in there own sheet. Thanks in Advance Dave ------------------------------- Hide it and make it visible in the worksheet_Activate event Application.Commandbars("myBar1").Visible = True -- HTH RP (remove nothere from the email address if mailing direct) |
#4
|
|||
|
|||
Thanks for a quick reply, Bob
I'm new to Excel, I've been looking were to put this code I've looked in the sheet, view code etc. Also looked in Help. I'm lost Could you tell me how and where to put this code. Application.Commandbars("myBar1").Visible = True ------------------------------- Hi All Is there a way to have a floating toolbar in say Sheet1 and one in Sheet2 with different names and they only show up in there own sheet. Thanks in Advance Dave ------------------------------- Hide it and make it visible in the worksheet_Activate event Application.Commandbars("myBar1").Visible = True -- HTH RP (remove nothere from the email address if mailing direct) |
#5
|
|||
|
|||
Dave,
Hope this helps Private Sub Workbook_SheetActivate(ByVal Sh As Object) If Sh.Name = "Sheet1" Then Application.CommandBars("myBar1").Visible = True Application.CommandBars("myBar2").Visible = False ElseIf Sh.Name = "Sheet2" Then Application.CommandBars("myBar1").Visible = False Application.CommandBars("myBar2").Visible = True End If End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code Change the sheet names and commandbar names accordingly. -- HTH RP (remove nothere from the email address if mailing direct) "Dave" wrote in message ... Thanks for a quick reply, Bob I'm new to Excel, I've been looking were to put this code I've looked in the sheet, view code etc. Also looked in Help. I'm lost Could you tell me how and where to put this code. Application.Commandbars("myBar1").Visible = True ------------------------------- Hi All Is there a way to have a floating toolbar in say Sheet1 and one in Sheet2 with different names and they only show up in there own sheet. Thanks in Advance Dave ------------------------------- Hide it and make it visible in the worksheet_Activate event Application.Commandbars("myBar1").Visible = True -- HTH RP (remove nothere from the email address if mailing direct) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to prevent "Reviewing" toolbar from "automatically" appearing? | Excel Discussion (Misc queries) | |||
Is there a way to lock in the toolbar settings?? | Excel Discussion (Misc queries) | |||
PDF 4.0 Floating Toolbar | Excel Discussion (Misc queries) | |||
"Drawing" Toolbar is inactive | Excel Discussion (Misc queries) | |||
How do I stop the Reviewing toolbar from showing up in Excel? | Excel Discussion (Misc queries) |