How can force enable macros to be able to open my workbook?
set up the workbook so that the only sheet showing is one with a message
which says "You must enable macros for this workbook to work." in a large
obvious font. Have the workbook password protected and all sheets
veryhidden.
In the workbook_Open event, hid that message-sheet & display the sheets
which you'd need to have visible.
So, if the user disables macros all they see is a sheet with a message on
it; If the open it with macros enabled, the Open event will kick in and make
the workbook work the way you want.
Bob Umlas
Excel MVP
"kcdonaldson" wrote in message
...
I would like to be able to force employees to enable macros for a certain
workbook or it will not let them open the workbook. And maybe put a
password
on it so if i would like to modify the workbook without the macros
enabled.
|