Form fields

[Vincent Crolla]

Hello everyone

I am building a document which uses fillable fields and an
Excel spreadsheet object. Once the doc is locked, I am
able to fill my fields but I can't open the spreadsheet.
The doc needs to be unlocked to gain acces to the
spreadsheet.

Can I get the best of both worlds?

I tried recording a macro, for gaining access to the
spreadseet, but it won't open the spreadsheet while
recording.

Thank you in advance...

 

[Laurie]

Hi
I solved this problem by recording a macro to unlock the
document and then in the final "Form Field" properties
set that macro to run on exit.

Or you might write a VB to unlock the document, and
replace all of the field codes with the code results.
Using a starting point bookmark.

 

[Charles Kenyon]

Can you put your spreadsheet object in a separate, unlocked, section?
--

Charles Kenyon

Word New User FAQ & Web Directory:
<URL: http://addbalance.com/word/index.htm>

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://addbalance.com/usersguide/index.htm>

See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

 

[Vincent Crolla]

Thanks Charles

I would prefer to keep it on one page but I could
certainly rearrange the doc.

 

[VIncent Crolla]

Thanks Laurie

Once the macro is recorded for unlocking the document, how
do I get the macro to open the object (Excel spreadsheet)?
In the record mode, Word won't let me double click on the
object.

Thanks again

 

[Cindy M -WordMVP-]

Hi Vincent,

Insert/Break, choose "Continuous". The unprotected section
would then only move to a new page if everything gets to be
too long for a single page (exactly when working normally
in Word).

Then go though Tools/Protect document and click "Sections"
so that you can deactivate the checkbox for this section.

If this isn't workable for you, let me know and I can give
you macro code to activate an embedded Excel worksheet
object.

I would prefer to keep it on one page but I could
certainly rearrange the doc.

unlocked, section?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
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

 

[Vincent Crolla]

Hi Cindy

Thank you for replying.

Breaking the embedded Excel object in a new section is not
workable because the user would have to go to the next
page, use Excel and now go back to the previous page to
continue. Performing these actions could be annoying for
the user.

Using macro code would surely save the day.

Thank you in advance

 

[Cindy M -WordMVP-]

Hi Vincent,

We're going around in circles. Please read the previous
messages very carefully. And I repeat the essence here, one
last time:

Placing (NOT breaking, placing) the Excel object in a new
section will NOT mean it has to be on a new page. There is
such a thing as a CONTINUOUS section break which allows you
to make numerous sections *on a single page*!!!!!

Please try it before replying back. Believe me, we KNOW what
we're talking about.

Breaking the embedded Excel object in a new section is not
workable because the user would have to go to the next
page, use Excel and now go back to the previous page to
continue. Performing these actions could be annoying for
the user.

Using macro code would surely save the day.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
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