How to stop user from changing some options

K

Ken Wan

Hi,
I am writing VBA code to turn off some options which are causing trouble
during the down-stream operations on Word document, such as
AutoFormatReplaceFractions. I am planning to associate my code with some
events such as Open doc, New doc, etc. However, after a document is openned
or created, the users can still use the Tools->Options, or
Format->AutoFormat->Options to change these options. I cannot totally
disable these Word commands since the users are still allowed to changes
othere options. Is there a way I can prevent users doing this?
Thanks in advance for your help.
Ken
 
M

martinique

Ultimately no. A determined user can always get to and restore the original
Word commands.

You can write macros with the same names as the built-in commands, which
will run when the functions are called in the usual ways; and you can remove
the options from the menus, toolbars, and keyboard shortcuts.

I think you'll find it's less work to deal with the files downstream: write
a filtering macro that checks for the things you don't want and deals with
them. In my experience every change imposed on users (of the sort you are
contemplating) has a support cost: you'll start getting phone calls from
users who want to know why their copy of Word no longer functions as they
expect; and when the boss's PA complains ...
 
K

Ken Wan

Hi, Martinique,
When the boss's PA complains ...
Glad my template is only intended for typiests only (-;.
Thanks for your input.
Ken
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top