F
Fable
I got a splash screen in place so users know that the macros have bee
enabled properly. However when the file is started it starts on “Error
Sheet telling user that they must enable macro and how. This was don
prevent user going into the file without enabling macro.
The issue is when the user does enable they can still see th
background of the error sheet instead of the main page, it’s not unti
the splash screen disappears; it redirects to the Main Page. I change
the order of events so the redirection would happen first on th
Workbook_Open, but it continues to show the error sheet. Any idea how
can avoid this, or get the Workbook_Open to follow the sequence I wan
and not execute the next line until it done with the previous.
Appreciate any help, thanks
enabled properly. However when the file is started it starts on “Error
Sheet telling user that they must enable macro and how. This was don
prevent user going into the file without enabling macro.
The issue is when the user does enable they can still see th
background of the error sheet instead of the main page, it’s not unti
the splash screen disappears; it redirects to the Main Page. I change
the order of events so the redirection would happen first on th
Workbook_Open, but it continues to show the error sheet. Any idea how
can avoid this, or get the Workbook_Open to follow the sequence I wan
and not execute the next line until it done with the previous.
Appreciate any help, thanks