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

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

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

In excel 97, there are no levels of security (either on or off) and
certification is not supported.

--
Regards,
Tom Ogilvy

"papou" wrote in message
...
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

oops sorry!
Did not notice the Excel 97 mention.
Apologies.
Cordially
Pascal

"Tom Ogilvy" a écrit dans le message de
...
In excel 97, there are no levels of security (either on or off) and
certification is not supported.

--
Regards,
Tom Ogilvy

"papou" wrote in message
...
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

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


.