Controls Move When Printed

There was an interesting discussion at the Xtreme Visual Basic forums that I learned about from Andy (Thanks). It seems that that with Excel XP and service pack 3 (SP-3), controls placed on a worksheet will move when printed or previewed. I’ve heard of this problem, but never experienced it myself; probably because I use Excel 2000 unless I have a compelling reason to use a different version.

The solution, believe it or not, is to group all the shapes on the sheet, then ungroup them. How that fixes it, I have no idea. If you have this problem or are just interested in it, be sure to read the thread:

Sheet Controls Moving After Print

Kudos to Helen for finding a solution.

Posted in Uncategorized

One thought on “Controls Move When Printed

Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.