Floating command button
 

Can anyone tell me if it possible to place command buttons into a custom
floating toolbar where the button will always remain visible regardless if
scrolling horizontally or vertically?

Thanks
Pat

Hi Pat,

Perhaps I don't get your point (question). But as far as I know, toolbars
are
always fixed on their latest location in the workbook window. They don't
react to
scrolling or zooming. Even when you risize (not minimize) the window, they
stay
fixed.

To add a button to a toolbar ... Is that the problem?
- Tools-Customize-tab Toolbars and then New
- tab Commands-category Macros
- drag Smiley to bar
- right click and Assign macro

Frans

"Pat" wrote in message
...
Can anyone tell me if it possible to place command buttons into a custom
floating toolbar where the button will always remain visible regardless if
scrolling horizontally or vertically?

Thanks
Pat

Hello Frans,

That was simple enough, I have created a new toolbar without any great
difficulty. Can I now use the toolbar I have created for a particular
worksheet? When the worksheet is activated the custom toolbar will also
appear, when I move to a different worksheet it will disappear. Is this
possible?

Pat

"Frans van Zelm" wrote in message
...
Hi Pat,

Perhaps I don't get your point (question). But as far as I know, toolbars
are
always fixed on their latest location in the workbook window. They don't
react to
scrolling or zooming. Even when you risize (not minimize) the window, they
stay
fixed.

To add a button to a toolbar ... Is that the problem?
- Tools-Customize-tab Toolbars and then New
- tab Commands-category Macros
- drag Smiley to bar
- right click and Assign macro

Frans

"Pat" wrote in message
...
Can anyone tell me if it possible to place command buttons into a custom
floating toolbar where the button will always remain visible regardless
if
scrolling horizontally or vertically?

Thanks
Pat

Hi Pat,

So that was the point: show / hide a toolbar when you activate a sheet.

Try the code below (Excel XP). It *must* be in the objectmodule for the
specific
sheet: right click the sheet tab and then View Code (or something like
that).

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

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

Frans

"Pat" wrote in message
...
Hello Frans,

That was simple enough, I have created a new toolbar without any great
difficulty. Can I now use the toolbar I have created for a particular
worksheet? When the worksheet is activated the custom toolbar will also
appear, when I move to a different worksheet it will disappear. Is this
possible?

Pat

etc.

Floating command button
 

I used this to great effect (Many thanks Frans!), but was wondering if
anybody could help me with a modification.

After using the Show/Hide macros, if I open the sheet in the worksheet
that has the floating toolbar, it doesn't show up, and also it stays if
I have two workbooks open and toggle between the two. Is there a way
to:

Make it appear when I open the workbook with that sheet active
Make the toolbar disappear when I ctrl-tab to another workbook.

All help very gratefully received.

Thanks,

Chris

Original Post by Frans:

Hi Pat,

So that was the point: show / hide a toolbar when you activate a
sheet.

Try the code below (Excel XP). It *must* be in the objectmodule for
the
specific
sheet: right click the sheet tab and then View Code (or something like
that).

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

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

Frans

Ends


--
Tibbs
------------------------------------------------------------------------
Tibbs's Profile: http://www.excelforum.com/member.php...o&userid=15947
View this thread: http://www.excelforum.com/showthread...hreadid=332856