C
Cresta
Hello and help.
I am getting frequent service desk calls regarding a heavily macro'd Excel
file freezing when it is being opened, and its all because the "Trust access
to Visual Basic Project" setting is not ticked.
I know the setting cannot be changed by code, for obvious security reasons,
so I am trying to get the file to check this setting at startup, give the
user a message to make the relevant setting changes, and to stop the file
from freezing.
Is there any simple code to check this setting and return a value to trigger
the above steps if required.
Thanks
I am getting frequent service desk calls regarding a heavily macro'd Excel
file freezing when it is being opened, and its all because the "Trust access
to Visual Basic Project" setting is not ticked.
I know the setting cannot be changed by code, for obvious security reasons,
so I am trying to get the file to check this setting at startup, give the
user a message to make the relevant setting changes, and to stop the file
from freezing.
Is there any simple code to check this setting and return a value to trigger
the above steps if required.
Thanks