I have created layered text boxes in order to create linked words in a
paragraph - layering the same linked text in it's own text box on top
of the unlinked text creates the illusion of a hyperlink without having
to link all the text in the cell or textbox.

The problem is twofold:
1) the text boxes don't maintain their position relative to each other
in between loads (when the document is closed and re-opened the boxes
sometimes shift by a few pixels)
2) the text boxes don't maintain their relative positions when printing
(the overlayed text boxes seem to float all over the place).

Is there a solution to either of these problems? I have tried grouping
the text boxes as well as locking the sheets to no effect. Any advice
appreciated!

Thanks,
Pauline

Does this KB help explain and or resolve your problem?
http://support.microsoft.com/?kbid=838910

Cheers
Andy

Pauline wrote:
I have created layered text boxes in order to create linked words in a
paragraph - layering the same linked text in it's own text box on top
of the unlinked text creates the illusion of a hyperlink without having
to link all the text in the cell or textbox.

The problem is twofold:
1) the text boxes don't maintain their position relative to each other
in between loads (when the document is closed and re-opened the boxes
sometimes shift by a few pixels)
2) the text boxes don't maintain their relative positions when printing
(the overlayed text boxes seem to float all over the place).

Is there a solution to either of these problems? I have tried grouping
the text boxes as well as locking the sheets to no effect. Any advice
appreciated!

Thanks,
Pauline


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info