+ Reply to Thread
Results 1 to 2 of 2

Floating Button - Possible?

Hybrid View

DCSwearingen Floating Button - Possible? 02-20-2007, 10:08 AM
pauluk To have the command work only... 02-20-2007, 11:07 AM
  1. #1
    Forum Contributor
    Join Date
    03-24-2005
    Location
    Wisconsin
    MS-Off Ver
    2007
    Posts
    378

    Floating Button - Possible?

    Is it possible to force a macro button to stay visible, or float, when scrolling around a spreadsheet? I would really like it to stay visible relative to where I place it in the work area.

    If so how do I do it?

    If not, how do I save a toolbar that will only be used by the Excel file for which I create it? In other words not stored in:
    C:\Documents and Settings\Username\Application Data\Microsoft\Excel\Excel11.xlb
    It needs to be contained within the workbook and close when the workbook is closed.
    Thanks!
    Dennis

    I am using Windows 7 and Office 2007, all of my posts are based on this.

  2. #2
    Registered User
    Join Date
    01-21-2004
    Location
    Liverpool
    MS-Off Ver
    2003
    Posts
    88
    To have the command work only with that workbook, then you would need to include the code in and auto open

    Sub AutoOpen()
    '
    'your code here
    '
    end sub
    however you will also need to have a auto close sub to remove that macro from the command bar

    sub AutoClose()
    '
    'yourcode
    '
    end sub
    another easy way would be to have your buttons on the top rows of the spreadsheet and the freeze the panes this will allow you to scroll around the spreadsheet and the bar buttons will alwasy be seen.

    regards
    Paul
    regards
    Paul
    http://www.frontlineuk.com
    FrontLineUK

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1