First you must accept the fact that macros can be a bad security risk to the
user if written with malicious intent. Not that you would, but they are out
there. The user has 3 levels of macro security to choose from: Run no macros
(High), Let me decide (Medium), and Run All Macros (Low). You or no code you
can write, have any control over what level the user has chosen. If the user
has chosen Low security, then your workbook with macros will open and run
with no pop-up dialog box. I know of no one who uses this setting, nor would
I ever ask a user to choose this setting just to run one of my workbooks.
So, to answer your question, the answer is 99.9% NO. However, there is an
alternative called Digital Signature. You can read up on it in the Help
files. Basically you create a digital signature that you can sign your
project code with. When a user opens your signed workbook, they will be
asked to add you to their trusted sources. Once they add your signature to
their trusted sources, your workbook code will run, no questions asked, no
matter what security level the user has chosen.
This is probably your best and only alternative here. The user still gets
that initial first time pop-up to add you to their trusted sources. Also
remember that each workbook you want opened this way that has macros in it,
must have your signature attached to it. A hyperlink to open another
workbook means that the other workbook must have your signature also.
Good Luck,
Mike F
