Question on "Splas Screens"

  • Thread starter Thread starter Paul Corrado
  • Start date Start date
P

Paul Corrado

I was using Walkenbach's Power Programming to develop a "Splash Screen" to
display a corporate logo on my spreadsheets when they are opened.

The issue I wish to get around is the need for the user to select the
"Enable Macro's" option in order for the screen to appear.

I certainly appreciate hearing from anyone who knows of a way to incorporate
such feature.

TIA

PC
 
If you could disable the users ability to enable or disable macros, you
would defeat the purpose of having that capability at all.

The only way you can disable the prompt is to certify you project in xl2000
or later (not supported in earlier than xl2000) and have the user accept
your certificate as a trusted source, or to lower the security setting (have
the user do it).

Alternatives are to use Addins or workbooks placed in the xlstart folder. In
the latest versions of Excel, I believe the user even has to OK the loading
of Addins as a security setting.
 
Although it doesn't quite address what you've asked (see Tom's comments), I
recently sent out on pre-release a workbook with macros in it. I sent the
file to a few friends as an email attachment with directions in the email.
Going back to the adage, "If something can go wrong, it will", I didn't
bother including info about what to do if the user didn't get any warning
about macros (e.g., if Security Level is set to High in Tools, Macros,
Security dialog box).

To provide instructions, I created a default sheet that was set to
xlSheetVisible. All other sheets (those with buttons on them) were set to
xlSheetVeryHidden. The instruction sheet had a paragraph stating that, "If
you are reading this, macros have not been enabled". The rest of the sheet
has screen captures of the various dialog boxes a user might see (e.g.,
Enable/Disable Macros, etc.) and what to do (e.g., Tools, Macros,
Security--set it to Medium).

If they make the changes and choose enable, the next time they open the
file, the instruction sheet's visible property is set to very hidden and the
other sheets are set to visible (can't have zero visible sheets, so have to
make a sheet visible before making instruction sheet not visible).

Anyway, I thought it was a neat work around for a problem I've faced before.

HTH,
Geoff

Enable Macros, Splash Screen, Macros don't run
 
Back
Top