Command Button keeps moving!

[ForSale]

Everytime i go to Print Preview, CommandButton3 moves to the left abou
10 columns. why is this the only button moving? and how can i preven
it from moving?
Thanks

 

[Dennis Brininger]

I have two quick options for you:

Option 1
1. in design mode, right click the button
2. Click Format Control
3. Click Properties
4. Select Don't move or size with cells

Option 2
program the controls location to reset after your code to
print preview is executed. You can see the location
settings by:
1. In design mod, right click the button
2. Click Properties
3. Write down the Hight, Left, Top, and Width values
4. Place the following in your code:
with CommandButton3
.Hight=27 'your value
.Left=153.75 'your value
.Top=67.5 'your value
.Width=59.25 'your value
End With

See if one of these work for you,

Dennis

 

[Dave Peterson]

xl2002????

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

 

[ForSale]

Thanks to both. I finally got it to stay there with the move AND size
with cells.
dennis, i like the idea of the code, however, i don't have a code to
print or print preview, it's just whenever the user clicks it. if this
current solution stops working, i'll use that code though.
thanks again.