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