Protecting sections with imported excel spreadsheets

[Lucy]

In my document is a form that contains checkboxes. That form needs to be
protected so the checkboxes will work. I added section breaks to protect that
section only, but it effects the other spreadsheets in other sections of the
document that I copied and pasted from excel (paste special so they act as
spreadsheets and calculate data), even though I applied protection only to
the section containing the checkboxes. Now, the spreadsheets don't open when
they are double clicked.

 

[Cindy M.]

Hi =?Utf-8?B?THVjeQ==?=,

In my document is a form that contains checkboxes. That form needs to be
protected so the checkboxes will work. I added section breaks to protect that
section only, but it effects the other spreadsheets in other sections of the
document that I copied and pasted from excel (paste special so they act as
spreadsheets and calculate data), even though I applied protection only to
the section containing the checkboxes. Now, the spreadsheets don't open when
they are double clicked.

You have to remove all text-wrap formatting from the spreadsheets. They have to
be located "in line with the text" in order for Word to be able to "see" them
when document protection is active.

If you want to have text flow around them (although spreadsheets are usually so
wide...) then you need to insert them into FRAMES. You'll find the Insert Frame
command in the Forms toolbar.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail