Hello George
I can think of two ways:
Either
change the user's security macro settings to Low
Or
Create a certficate with SELFCERT.EXE, attach it to your VBProject and Save
and then distribute your workbook.
In which case the next time your users will open the workbook, the message
will be slightly different (but still asking for activating macros) as it
will include a checkbox to tick to permanently allow macros with the given
certificate.
Once the checkbox will be ticked, next time macros will be automatically run
without any security prompt.

HTH
Cordially
Pascal

"George J" a écrit dans le message de
...
I have a nasty feeling that this is not possible, but...

I have a workbook that shows a splash screen if macros are
not enabled so that the user knows they need to enable
macros to get any further.

The problem i have is that a userform on this workbook
will open another workbook (in a new excel application
using shell "excel.exe"), that also has macros, but i
don't want the macro warning to be displayed. Is there any
way of doing this - because the user has agreed that they
want to run macros to access the original workbook??

I am using excel97 so can't use this
'----------------------------------------------------------
Application.AutomationSecurity =
msoAutomationSecurityForceDisable
'----------------------------------------------------------

The reason i ask is that many of the users are confused as
to what they should do when the message and options come
up. (management)

thanks
George