Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Regarding Command Button

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    I'm using command buttons and the data filter function in one om my workbooks.

    My command buttons are always moving when I use the filter function.

    My question is: Is it possible to place a command button in a constant position (altitude/width) from the top of the sheet?

    andy-s

  2. #2
    Board Regular George J's Avatar
    Join Date
    Feb 2002
    Location
    Edinburgh, Bonnie Scotland
    Posts
    957
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Don't have access to excel, but this should be along the right lines.

    Add msoBarFloating to its position:
    Application.CommandBars.Add("Button", Position:=msoBarFloating, temporary:=True)

    Not used buttons for quite some time though.
    George J

  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Andy

    1) Get into Design Mode
    2) Right click command button
    3) Select Format control
    4) Select Properties
    5) Select Don't move or size with cells


    Kind Regards,
    Ivan F Moala From the City of Sails

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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