It probably all boils down to my poor coding and lack of
experience.

This is the first time i have used userforms and as my
workbook worked on its own, wanted to keep it working.
Will have a look at some of the code when i'm not
brainfried. I tried using OLE Automation (i think) in a
message you replied to yesterday but it wasn't running the
workbook.open command so that was why i went with
shell "excel.exe"

http://search.communities.microsoft....roups/previewF
rame.asp?
ICP=prod_office&sLCID=US&sgroupURL=microsoft.publi c.excel.p
rogramming&sMessageID=%253C146201c49bed%24306c87f0 %
%253E

I was concerned that if the user already had documents
open i will not be able to get them to close them down and
serious screwups could result. That is why i am trying to
get it started in a new application.
But i think you are right and i should be able to
reference the wb the changes are to be made in. I think
right now i have if activeworkbook = a, use b.

Something stupid like that.

thanks for trying to help.
nothing a brain transplant can't cure ?:-)

George

-----Original Message-----
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


.