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

--
Message posted from http://www.ExcelForum.com

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



-----Original Message-----
Everytime i go to Print Preview, CommandButton3 moves to
the left about
10 columns. why is this the only button moving? and
how can i prevent
it from moving?
Thanks,


---
Message posted from http://www.ExcelForum.com/

.

xl2002????

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

"ForSale <" wrote:

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

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

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.


---
Message posted from http://www.ExcelForum.com/