Hello,

I have a word document with a drop down form field. I also have a table
cell with a paragraph of text in. I am writing a macro to make the
paragraph of text change depending on what is selected in the drop down
box.

I can write a macro to cause the table text to change however I need to
have somewhere to put all the paragraphs of text that aren't currently
visible on the document where they can be referred to when needed. I
want everything to be inside the one .doc file and I don't want to embed
the paragraphs into the VBA code.

Is there a 'proper' way to do this, a way to contain data (possibly a
large amount) in a form that a macro can refer to, that regular user
won't see?

Is is possible to somehow have entire pages with formatting, tables,
images etc hidden from regular users (if not always at least when the
form is in protected mode)?

Cheers,

David