 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / November 2007Floating Button
Is it possible to have a button float, and move as the sheet scrolls down or up? I use a long sheet and use a button with a macro and would like it close to the cursor. THNX I'm not aware of a way to do this (although there might be one). If the button's not too big, you could just put somewhere on Row 1 and freeze Row 1 so the button stays visible. James > Is it possible to have a button float, and move as the sheet scrolls > down or up? [quoted text clipped - 3 lines] > > THNX Well, this seems to work. Note that it changes the button location when you change the selected cell, not when you scroll. I used a button from the Forms toolbar. Not tested on a button from the Control toolbar. This goes in the worksheet module (click on worksheet's tab, select View code, paste code in there). HTH, James Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveSheet.Buttons(1).Top = ActiveCell.Top End Sub > I'm not aware of a way to do this (although there might be one). If the > button's not too big, you could just put somewhere on Row 1 and freeze Row [quoted text clipped - 6 lines] >> >> THNX that should be RIGHT-click on worksheet's tab > Well, this seems to work. Note that it changes the button location when > you change the selected cell, not when you scroll. I used a button from [quoted text clipped - 16 lines] >>> >>> THNX > I'm not aware of a way to do this (although there might be one). If the > button's not too big, you could just put somewhere on Row 1 and freeze Row 1 [quoted text clipped - 8 lines] > > > THNX True. Actualy thats what i did, still wanted to verify if the floating part was possible. thnx ZONE On Oct 17, 3:49 pm, Luis A. V?zquez <upslavazq...@gmail.com> wrote: > > I'm not aware of a way to do this (although there might be one). If the > > button's not too big, you could just put somewhere on Row 1 and freeze Row 1 [quoted text clipped - 13 lines] > > thnx ZONE ZONE....Tried it and works fine. It will serve the purpose. Thnx You're welcome, Luis. Thanks for the feedback. James > On Oct 17, 1:33 pm, "Zone" <KingOfWhi...@aol.com> wrote: > [quoted text clipped - 17 lines] > > thnx ZONE ZONE....Tried it and works fine. It will serve the purpose. Thnx I have been looking for a similar solution, but I have several buttons along the left-hand side of the sheet (an alphabetical letter index that filters the sheet). I have headers in the first row and have frozen the top row for scrolling purposes (obviously all 26 of my buttons would not fit into the scheme described by Zone below). Is there no way to create free-floating buttons independent of any scrolling within the sheet? It seems like this functionality should be available, but I can't figure it out. Any assistance would be greatly appreciated. Thanks. > I'm not aware of a way to do this (although there might be one). If the > button's not too big, you could just put somewhere on Row 1 and freeze Row 1 [quoted text clipped - 6 lines] > > > > THNX |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.