Floating Control Button

**RKleebaum** · 04-04-2010, 11:57 AM

I am looking to create control buttons (with assigned macros) that will float over the spreadsheet and therefore will still be visible the user scrolls down the worksheet.

**royUK** · 04-04-2010, 12:04 PM

You want a floating Toolbar,seethe examplesat the bottomof this page

http://excel-it.com/vba_examples.htm

**RKleebaum** · 04-04-2010, 12:55 PM

Thanks for your prompt response. I did see some examples, but was unable to determine which one addressed my concern. Maybe I'm just being 'slow' today.

**royUK** · 04-04-2010, 01:31 PM

The Add a Toolbar at the bottom of the sheet, note this will only work in versions prior to Excel 2007

**RKleebaum** · 04-05-2010, 09:54 AM

Excellent...thank you. I apologize for the senior moment. One final question, how do I get it to autormatically run the Create_Toolbar macro when I open the file?

**royUK** · 04-05-2010, 11:01 AM

The code todo that is in the example

Option Explicit

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call Delete_Bar
End Sub

Private Sub Workbook_Open()
Call Create_Bar
End Sub

**RKleebaum** · 04-05-2010, 11:08 AM

Excellent!! Thank you for your help. I will now try and figure out how to set this as 'solved' and rate the response.

**royUK** · 04-05-2010, 11:41 AM

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save