Not allow to open file it do not accept macros
 

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.

Not allow to open file it do not accept macros
 

There is no way to force it, but one work-around is to include a sheet with a notice "Hey! You need
to open this with macros enabled! Close and re-open!" that is the only visible sheet when the file
is saved. Then use macros to hide that sheet and unhide the others: if the user doesn't enable
macros, the sheets aren't unhidden and they only get the message.

HTH,
Bernie
MS Excel MVP


"JR_06062005" wrote in message
...
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.