Hi there,
I use Excel to produce calculations, and as such need a header block at the top of each sheet. To achieve this, I've created a grouped set of text boxes as shown in the attached to present the information I desire at the top of each sheet. This allows me to readily update the header block info manually, or via VBA.
The issue I have is that after carefully sizing and positioning the text boxes to look good on my machine, as soon as a colleague opens this on another computer everything shifts, and also prints incorrectly. The text spacing changes, the relative position of the text boxes is altered. It's a mess.
Is there any plan to fix this issue? Is there a workaround to avoid it? Possibly by use of Forms, or do these shift too?
Note: I'm fully aware of the Header/Footer feature, but this is really limited which I why I moved away from it. My question relates more generally to shifting shape objects, which appears to be a severed limitation in what can be achieved with them when sharing workbooks between machines. So please limit responses to this issue; the Header/Footer feature is too clunky for my use.
Cheers,
Dan
Bookmarks