R
Ray Maas
I have a macro that needs to run when my users open a spreadsheet.
Unfortunately, most of their security settings do not allow macros to run.
I know this cannot be overridden in VBA, that would defeat the purpose of
the security.
So how, in VBA, can I check to see if they have selected to disable macros,
then give them a messagebox that says something like "sorry, you have to
enable macros to use this application"?
Thanks,
Ray Maas
Unfortunately, most of their security settings do not allow macros to run.
I know this cannot be overridden in VBA, that would defeat the purpose of
the security.
So how, in VBA, can I check to see if they have selected to disable macros,
then give them a messagebox that says something like "sorry, you have to
enable macros to use this application"?
Thanks,
Ray Maas