MS Word - FILLIN/ASK fields

damianjmcgrath

Board Regular
Joined
Oct 31, 2008
Messages
72
Hello,

I have a problem concerning FILLIN and ASK fields.
I have a mix of these fields in my document. When I open the .dot file, it only shows the FILLIN fields and doesnt show the ASK fields. I researched this and found on the internet that I needed to create a macro called autonew and put in a line of code to say: ActiveDocument.Fields.Update to make the ASK fields show themselves.

This worked.

However, it now shows the FILLIN fields, then the ASK fields, then the FILLIN fields again with my typed answers already present.

How can I get it to prompt the FILLIN and ASK fields on document open, just once?

Thanks.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Actually, I think it's solved - apparently, I had to increase the code to include the line:

ActiveDocument.Fields.Locked = False

and then highlight my FILLIN fields in my document, and press Ctrl+F11 to lock them. They then won't be updated until my code runs, so they only appear once.

It seems to be working at the moment but I'll post back if it's only a temporary solution.
 
Upvote 0

Forum statistics

Threads
1,225,462
Messages
6,185,129
Members
453,279
Latest member
MelissaOsborne

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top