Hi Stevepain!

try this:

Right click on the button -- Format Control -- Properties Tab -- and
select the option button "Don´t move or size with cells"

this should solve this problem!

or if you don´t need to print the button you can uncheck the checkbox "Print
object" at this same way!

i hope this tip can help you!

PEdro


"stevepain" wrote:


Hi all,

Fairly minor, but niggly point here. I am using Excel 2002, and have
got some control box buttons on a couple of worksheets that run
macros.

Everytime I print, or print preview the worksheet, the button moves
from it's location on the sheet and obscures some of the data. The
button is set such that it is not printed, however, it is annoying me
that it keeps moving!

Any suggestions?

Merry Christmas everyone!

Steve


--
stevepain
------------------------------------------------------------------------
stevepain's Profile: http://www.excelforum.com/member.php...o&userid=21759
View this thread: http://www.excelforum.com/showthread...hreadid=495477