Restoring a User's Tools|Options to original state after running a macro
I've built a series of forms I wish to distribute to my colleagues to make
their internal reporting chores a little easier.
When an operator runs one of these forms, I want it to look exactly like it
does on **MY**
machine. I've had to tweak some settings on my system to get these form
running correctly and it's unsafe to assume the operator's machine is set up
"properly adjusted."
For example, I've had to change the:
a. Tools|Options|View|Screen Tips --> ON
b. Tools|Options|View|Field Shading --> ALWAYS
c. Tools|Options|View|Field Codes --> ON
d. and then delete the "Add AutoText" option to the AutoText Menu bar.
I could write this into the AutoNew macro that fires up my form so that it
will run properly, but I
consider that pretty rude since I don't know how to put the user's machine
back the way it was after my form template has run its course. Some users
might not notice. Others most certainly will....
So is there some way to "capture the state" of the end-user's setup, change
these user-specified settings to meet **my** macro's needs, and THEN RESTORE
THE USER'S MACHINE to its pre-template/AutoNew macro condition?
Rick Rodgers
PS Please dig out the !nospam! from my address if you want to reply to me
personally, OK?
