Is the a way so that I can make it so that a user cannot open a file unless
he/she allows macros?
I fashioned an Excel worksheet into a input form. The workbook containing
the form has lots of
VB, lookup tables and hidden columns, formulas and
sheets. It works remarkedly well except for one problem. Some users insist
on disallowing macros when they open the file and then not only does the
input form not function, but since I've used
VB to protect the form, they
usually mess up the form and all the data previously input to the form. In
sending out the form, I've instructed the users to Accept Macros, but
invariably there are some who do not follow that simple instruction. The
results is both the user and I spend a lot time correcting the mess.
Any help and/or suggestions in solving this problem will be appreaciated.