Brett,

You can set the properties of the button to NOT print.
This way it doesn't matter where the button is.

--
steveB

Remove "AYN" from email to respond
"Brett" wrote in message
...
All-

I've got a worksheet with three buttons on it. The code behind each
button works, just great, but when I try to print (or print preview) the
worksheet, one or more buttons shift to the left, sometimes appearing on
the printout. i.e. the buttons are over columns I & J, and after
printing, they're usually covering columns B & C.

I've set the active print area, and set my margins to ensure that I'm
printing only the text, and not the buttons.

Any thoughts on why this would be happening?

btw- I'm going to try moving them to the top, or right of the worksheet,
but I'd still like to know why they move in the first place.

Thanks!
bds