Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open file with macros | Excel Discussion (Misc queries) | |||
Macros forcing file open | Excel Programming | |||
Open file without macros | Excel Programming | |||
In VBA, Open a file with macros disabled | Excel Programming | |||
How can I have a macros automatically run when I open up the file. | Excel Programming |