Form fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vincent Crolla - 12 Jan 2004 22:28 GMT

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...

Reply to this Message

Laurie - 12 Jan 2004 23:45 GMT

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.

>-----Original Message-----
>Hello everyone
[quoted text clipped - 13 lines]
>Thank you in advance...
>.

Reply to this Message

VIncent Crolla - 13 Jan 2004 14:34 GMT

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

>-----Original Message-----
>Hi
[quoted text clipped - 26 lines]
>>
>.

Reply to this Message

Charles Kenyon - 13 Jan 2004 04:15 GMT

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

Signature

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.

> Hello everyone
>
[quoted text clipped - 11 lines]
>
> Thank you in advance...

Reply to this Message

Vincent Crolla - 13 Jan 2004 14:13 GMT

Thanks Charles

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

>-----Original Message-----
>Can you put your spreadsheet object in a separate, unlocked, section?
[quoted text clipped - 15 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 14 Jan 2004 17:52 GMT

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.
>
> >-----Original Message-----
> >Can you put your spreadsheet object in a separate,
> 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

:-)

Reply to this Message

Vincent Crolla - 16 Jan 2004 16:55 GMT

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

>-----Original Message-----
>Hi Vincent,
[quoted text clipped - 29 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 18 Jan 2004 17:50 GMT

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
[quoted text clipped - 3 lines]
>
> 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 :-)

Reply to this Message