labels and text boxes move during printing

[miconian]

I have a bunch of labels and text boxes in Row 1. I have them locked so they do not move when columns are resized. But when the worksheet is printed, they get all jumbled up...not just on the printed page, but in the actual worksheet as well. What can I do to prevent this?

Thanks!

 

[miconian]

Oddly (?), if I just select a print area from within the other rows, and print that, there isn't a problem...

 

[miconian]

Maybe I need to anchor all the text boxes and labels to a form? But it would have to be a form that was always present, even when data was being entered into other parts of the worksheet (i.e. it would have to be non-modal). Is that possible?

 

[Von Pookie]

See if this fixes it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;838910&Product=xl2002

 

[Zack Barresse]

Other than the link Kristy provided, I know of no other solution. So my addition to this thread will be shaped as a question then.

To someone with Excel v11 (2003): Does this also happen in said version?

I only have 2000 and 2002 to test. So I'm curious if this was fixed in 2003 or not. Just curious mainly.

 

[miconian]

Von Pookie, thanks for the referal, but it doesn't help. I don't have service pack 3 installed, and I have to have my controls set to 'don't move or size with cells,' because the users often resize the columns and that in itself causes essentially the same problem.

 

[miconian]

I found that when you associate all the affected items together as a 'group' it pretty much takes care of the problem.