Open workbook-macros enabled, opening another with macros
Use OLE automation to open the other instance of Excel and open the workbook
( don't believe this raises the prompt). But why not open it in the current
instance? I am sure you have a legitimate reason.
--
Regards,
Tom Ogilvy
"George J" wrote in message
...
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
|