I have searched long and hard for the solution to this problem.

I have a complicate form using Excel as a platform and VBA to control and
manage the form.

Its completed by users on a network.

my problem is this:

information from another source is brought into the form and populates
sections of this form. Thi info first goes to a cell on an information sheet
which is not seen or used by user (xlveryhiddedn). this is linked to the text
box. Because this info is more than 1024 characters long but is lno more than
2000 characters long I have used text boxes embedded on the form created
from the control toolbox.

What i now want to do is prevent users from adding to or changing the
information that comes into the form. now i have changed the enabled
propperty to false which does the job BUT this grays the text on view ( not
too much of a problem) but on printing makes it virtually unreadable.

ok with VBA code

hope this enouth info

thanks in advance

--
Message posted via http://www.officekb.com