How to automatically enable macros?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Saw this question posted days ago. Sorry for the repeat -- couldn't find the
original.
I've created a form to be sent to several users. To save them the trouble of
exiting Design Mode, lowered the security level to Medium so they'd be asked
when they opened if they wanted to Enable Macros. Now when file opens and
Enable Macros is pressed, an error message pops up saying "Can't exit design
mode because Control DefaultOcxName17 cannot be created".
Need to fix this error, or find another way to enable macros.

Help!
 
Saw this question posted days ago. Sorry for the repeat -- couldn't find the
original.
I've created a form to be sent to several users. To save them the trouble of
exiting Design Mode, lowered the security level to Medium so they'd be asked
when they opened if they wanted to Enable Macros. Now when file opens and
Enable Macros is pressed, an error message pops up saying "Can't exit design
mode because Control DefaultOcxName17 cannot be created".
Need to fix this error, or find another way to enable macros.

Help!
Click to expand...
Also: can the form be set up so the user can tab between the different text
boxes? Right now the user must mouse-click to each box.
 
I think you've used the wrong feature for the type of form you need. Instead
of inserting ActiveX controls (which are really designed for UserForms and
which trigger the macro warning), use the form fields from the Forms
toolbar. With a protected form, users will not get a macro warning, and Tab
will take them from one field to the next. For more information on protected
forms, see http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm and
especially the forms tutorials by Dian Chapman that this article links to.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Drat. Hoped there was a way to keep the ActiveX controls. I prefer them
because they allow text entry for multiple lines without actually changing
the length of the form. The text boxes from the Forms toolbar cause the form
to lengthen with each additional line.
Is there a way to change that?
Functionally I'm not happy with it, but it doesn't look as good as the
ActiveX either. Can the Forms toolbar textbox be snazzed up?
 
If you're using the form to collect information to be inserted into a
document, then a UserForm is a good application, but if this is for a
printed form, you're better off with the forms controls. You can limit the
text area by putting the form fields in a (borderless) table with Exact row
height and Preferred column width (and AutoFit turned off).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Back
Top