L
Laphan
Hi All
Having real trouble finding out how to do this.
Basically I have done a Word doc that uses Form fields so that I can
auto-copy the contents of say 20 form fields into designated areas of the
remaining doc.
My problem is that textboxes don't seem to auto-update when the user has
tabbed out of a form field (cells in tables do), so I've a little VBA macro
function that goes through all of the references and forces them to update -
inc the textboxes.
My problem is that I need the user to click the padlock icon on the forms
toolbar to unlock the doc so that the user can then click on this macro to
run it.
This 'unclick padlock then click Macro' procedure has to be done for each
copy of the Word doc template that they use, but the user is fine with that.
My functional problem is that I:
a) Can't get the Forms toolbar to be already displayed when the user opens
the copy doc from the template.
b) Can't get my Macro to appear as a clickable toolbar/item/button when the
user opens the copy doc from the template.
Although displaying the Forms toolbar isn't too much of an onerous task for
the user, ie they go View / Toolbars / Forms, getting the Macro to appear on
the menu/toolbar is way too much hassle.
Is there no way, either via VBA or something even more simpler, I can get
these details to auto-display as the user opens the copy doc?
Thanks
Having real trouble finding out how to do this.
Basically I have done a Word doc that uses Form fields so that I can
auto-copy the contents of say 20 form fields into designated areas of the
remaining doc.
My problem is that textboxes don't seem to auto-update when the user has
tabbed out of a form field (cells in tables do), so I've a little VBA macro
function that goes through all of the references and forces them to update -
inc the textboxes.
My problem is that I need the user to click the padlock icon on the forms
toolbar to unlock the doc so that the user can then click on this macro to
run it.
This 'unclick padlock then click Macro' procedure has to be done for each
copy of the Word doc template that they use, but the user is fine with that.
My functional problem is that I:
a) Can't get the Forms toolbar to be already displayed when the user opens
the copy doc from the template.
b) Can't get my Macro to appear as a clickable toolbar/item/button when the
user opens the copy doc from the template.
Although displaying the Forms toolbar isn't too much of an onerous task for
the user, ie they go View / Toolbars / Forms, getting the Macro to appear on
the menu/toolbar is way too much hassle.
Is there no way, either via VBA or something even more simpler, I can get
these details to auto-display as the user opens the copy doc?
Thanks