Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I stop my command Buttons from shifting?

Status
Not open for further replies.

reimbursement

Programmer
May 5, 2003
7
US
I have two command Buttons on a spreadsheet. After I click on one of the buttons the buttons reposition themselves to the right. How can I stop the buttons from moving around. Thanks!
 
What version? I have tried both Form buttons, and ActiveX buttons and I can not duplicate this behaviour in Excel 2002.

Gerry
See my Paintings and Sculpture
 
What do the buttons do when you click them? Do they run some code that may be causing this?

----------------------------------------------------------------------------
[peace]It's easier to beg forgiveness than ask permission[2thumbsup]
----------------------------------------------------------------------------
 

Here is the macro the button calls in. I am running Excel 2002.

Range("A3").Select
Application.CutCopyMode = False
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

The other button does not cause the buttons to relocate.
 
There's no question they move to the right and not the left I suppose?

Reason I ask is:-


Regards
Ken............

----------------------------------------------------------------------------
[peace]It's easier to beg forgiveness than ask permission[2thumbsup]
----------------------------------------------------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top