After all this time I have a program that does fine on my comp. When I put it
on another it says go to online help for macros enable. On my comp when I
open it asks to enable. Is there any code that I can put into excel to have
it enable when opening or to display screen that allows enable. Have become
aware of security settings. Assumeing they are high on foreign comp.
Thanks for any assistance.

Hi

Can you check if Application.AutomationSecurity helps you

Sub Security()
Dim secAutomation As MsoAutomationSecurity

secAutomation = Application.AutomationSecurity

Application.AutomationSecurity = msoAutomationSecurityByUI
Workbooks.Open (sFileName)

Application.AutomationSecurity = secAutomation

End Sub

Cheers
Shasur
--
http://vbadud.blogspot.com


"Curt" wrote:

> After all this time I have a program that does fine on my comp. When I put it
> on another it says go to online help for macros enable. On my comp when I
> open it asks to enable. Is there any code that I can put into excel to have
> it enable when opening or to display screen that allows enable. Have become
> aware of security settings. Assumeing they are high on foreign comp.
> Thanks for any assistance.

You cannot force a system with "high security settings" to run your code.
Think about it. First, how would that code run if the security settings stop
code from running? Second, if you were able to do that, it would defeat the
purpose of having security settings in the first place. If your user is to
be able to run your macros, they will have to adjust their Excel settings to
either permit macros to run directly (not advisable) or to prompt them if it
is alright to run macros (better).

--
Rick (MVP - Excel)


"Curt" <(E-Mail Removed)> wrote in message
news:6F058A90-3C92-466B-B693-(E-Mail Removed)...
> After all this time I have a program that does fine on my comp. When I put
> it
> on another it says go to online help for macros enable. On my comp when I
> open it asks to enable. Is there any code that I can put into excel to
> have
> it enable when opening or to display screen that allows enable. Have
> become
> aware of security settings. Assumeing they are high on foreign comp.
> Thanks for any assistance.

My problem is getting to the promp screen to allow macros to run. Does
security need to be reset to allow this screen to apear in excel? If so then
I will create a doc to explain how to do it. Novices as we are we are getting
there.
Thanks for assistance

"Rick Rothstein" wrote:

> You cannot force a system with "high security settings" to run your code.
> Think about it. First, how would that code run if the security settings stop
> code from running? Second, if you were able to do that, it would defeat the
> purpose of having security settings in the first place. If your user is to
> be able to run your macros, they will have to adjust their Excel settings to
> either permit macros to run directly (not advisable) or to prompt them if it
> is alright to run macros (better).
>
> --
> Rick (MVP - Excel)
>
>
> "Curt" <(E-Mail Removed)> wrote in message
> news:6F058A90-3C92-466B-B693-(E-Mail Removed)...
> > After all this time I have a program that does fine on my comp. When I put
> > it
> > on another it says go to online help for macros enable. On my comp when I
> > open it asks to enable. Is there any code that I can put into excel to
> > have
> > it enable when opening or to display screen that allows enable. Have
> > become
> > aware of security settings. Assumeing they are high on foreign comp.
> > Thanks for any assistance.
>
>

If security is set at high or very high the user will not get the prompt and
macros will be diabled.

Security set to medium prior to the workbook being opened will raise the
prompt.

If the workbook is signed and trusted, no prompt will appear but macros will
be enabled.


Gord Dibben MS Excel MVP

On Wed, 17 Dec 2008 10:27:01 -0800, Curt <(E-Mail Removed)>
wrote:

>My problem is getting to the promp screen to allow macros to run. Does
>security need to be reset to allow this screen to apear in excel? If so then
>I will create a doc to explain how to do it. Novices as we are we are getting
>there.
>Thanks for assistance
>
>"Rick Rothstein" wrote:
>
>> You cannot force a system with "high security settings" to run your code.
>> Think about it. First, how would that code run if the security settings stop
>> code from running? Second, if you were able to do that, it would defeat the
>> purpose of having security settings in the first place. If your user is to
>> be able to run your macros, they will have to adjust their Excel settings to
>> either permit macros to run directly (not advisable) or to prompt them if it
>> is alright to run macros (better).
>>
>> --
>> Rick (MVP - Excel)
>>
>>
>> "Curt" <(E-Mail Removed)> wrote in message
>> news:6F058A90-3C92-466B-B693-(E-Mail Removed)...
>> > After all this time I have a program that does fine on my comp. When I put
>> > it
>> > on another it says go to online help for macros enable. On my comp when I
>> > open it asks to enable. Is there any code that I can put into excel to
>> > have
>> > it enable when opening or to display screen that allows enable. Have
>> > become
>> > aware of security settings. Assumeing they are high on foreign comp.
>> > Thanks for any assistance.
>>
>>

Is there any difference in the settings between XP & Vista in security
settings. Both my comp & another are set on medium high. Mine gives a choice
to enable macros the other running Vista with office 2000 same as me asks to
go to online help to enable. I will go back to other comp next week and try
lower settings. As you said medium I hope that is medium high.
Thanks for the input Sure does make a person have confidence when you have
mor knowledgeable one to turn to.
Thanks Again

"Gord Dibben" wrote:

> If security is set at high or very high the user will not get the prompt and
> macros will be diabled.
>
> Security set to medium prior to the workbook being opened will raise the
> prompt.
>
> If the workbook is signed and trusted, no prompt will appear but macros will
> be enabled.
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 17 Dec 2008 10:27:01 -0800, Curt <(E-Mail Removed)>
> wrote:
>
> >My problem is getting to the promp screen to allow macros to run. Does
> >security need to be reset to allow this screen to apear in excel? If so then
> >I will create a doc to explain how to do it. Novices as we are we are getting
> >there.
> >Thanks for assistance
> >
> >"Rick Rothstein" wrote:
> >
> >> You cannot force a system with "high security settings" to run your code.
> >> Think about it. First, how would that code run if the security settings stop
> >> code from running? Second, if you were able to do that, it would defeat the
> >> purpose of having security settings in the first place. If your user is to
> >> be able to run your macros, they will have to adjust their Excel settings to
> >> either permit macros to run directly (not advisable) or to prompt them if it
> >> is alright to run macros (better).
> >>
> >> --
> >> Rick (MVP - Excel)
> >>
> >>
> >> "Curt" <(E-Mail Removed)> wrote in message
> >> news:6F058A90-3C92-466B-B693-(E-Mail Removed)...
> >> > After all this time I have a program that does fine on my comp. When I put
> >> > it
> >> > on another it says go to online help for macros enable. On my comp when I
> >> > open it asks to enable. Is there any code that I can put into excel to
> >> > have
> >> > it enable when opening or to display screen that allows enable. Have
> >> > become
> >> > aware of security settings. Assumeing they are high on foreign comp.
> >> > Thanks for any assistance.
> >>
> >>
>
>

XP and Vista are operating systems and should have no bearing on security
options in Excel but I don't run Vista so not sure.

You are changing the securioty settings in Excel, right?

I never heard of a "medium high" setting but then I have never used Excell
2000 either.


Gord

On Wed, 17 Dec 2008 23:18:01 -0800, Curt <(E-Mail Removed)>
wrote:

>Is there any difference in the settings between XP & Vista in security
>settings. Both my comp & another are set on medium high. Mine gives a choice
>to enable macros the other running Vista with office 2000 same as me asks to
>go to online help to enable. I will go back to other comp next week and try
>lower settings. As you said medium I hope that is medium high.
>Thanks for the input Sure does make a person have confidence when you have
>mor knowledgeable one to turn to.
>Thanks Again
>
>"Gord Dibben" wrote:
>
>> If security is set at high or very high the user will not get the prompt and
>> macros will be diabled.
>>
>> Security set to medium prior to the workbook being opened will raise the
>> prompt.
>>
>> If the workbook is signed and trusted, no prompt will appear but macros will
>> be enabled.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Wed, 17 Dec 2008 10:27:01 -0800, Curt <(E-Mail Removed)>
>> wrote:
>>
>> >My problem is getting to the promp screen to allow macros to run. Does
>> >security need to be reset to allow this screen to apear in excel? If so then
>> >I will create a doc to explain how to do it. Novices as we are we are getting
>> >there.
>> >Thanks for assistance
>> >
>> >"Rick Rothstein" wrote:
>> >
>> >> You cannot force a system with "high security settings" to run your code.
>> >> Think about it. First, how would that code run if the security settings stop
>> >> code from running? Second, if you were able to do that, it would defeat the
>> >> purpose of having security settings in the first place. If your user is to
>> >> be able to run your macros, they will have to adjust their Excel settings to
>> >> either permit macros to run directly (not advisable) or to prompt them if it
>> >> is alright to run macros (better).
>> >>
>> >> --
>> >> Rick (MVP - Excel)
>> >>
>> >>
>> >> "Curt" <(E-Mail Removed)> wrote in message
>> >> news:6F058A90-3C92-466B-B693-(E-Mail Removed)...
>> >> > After all this time I have a program that does fine on my comp. When I put
>> >> > it
>> >> > on another it says go to online help for macros enable. On my comp when I
>> >> > open it asks to enable. Is there any code that I can put into excel to
>> >> > have
>> >> > it enable when opening or to display screen that allows enable. Have
>> >> > become
>> >> > aware of security settings. Assumeing they are high on foreign comp.
>> >> > Thanks for any assistance.
>> >>
>> >>
>>
>>

My error I was doing it in internet options.
Thanks

"Gord Dibben" wrote:

> XP and Vista are operating systems and should have no bearing on security
> options in Excel but I don't run Vista so not sure.
>
> You are changing the securioty settings in Excel, right?
>
> I never heard of a "medium high" setting but then I have never used Excell
> 2000 either.
>
>
> Gord
>
> On Wed, 17 Dec 2008 23:18:01 -0800, Curt <(E-Mail Removed)>
> wrote:
>
> >Is there any difference in the settings between XP & Vista in security
> >settings. Both my comp & another are set on medium high. Mine gives a choice
> >to enable macros the other running Vista with office 2000 same as me asks to
> >go to online help to enable. I will go back to other comp next week and try
> >lower settings. As you said medium I hope that is medium high.
> >Thanks for the input Sure does make a person have confidence when you have
> >mor knowledgeable one to turn to.
> >Thanks Again
> >
> >"Gord Dibben" wrote:
> >
> >> If security is set at high or very high the user will not get the prompt and
> >> macros will be diabled.
> >>
> >> Security set to medium prior to the workbook being opened will raise the
> >> prompt.
> >>
> >> If the workbook is signed and trusted, no prompt will appear but macros will
> >> be enabled.
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >> On Wed, 17 Dec 2008 10:27:01 -0800, Curt <(E-Mail Removed)>
> >> wrote:
> >>
> >> >My problem is getting to the promp screen to allow macros to run. Does
> >> >security need to be reset to allow this screen to apear in excel? If so then
> >> >I will create a doc to explain how to do it. Novices as we are we are getting
> >> >there.
> >> >Thanks for assistance
> >> >
> >> >"Rick Rothstein" wrote:
> >> >
> >> >> You cannot force a system with "high security settings" to run your code.
> >> >> Think about it. First, how would that code run if the security settings stop
> >> >> code from running? Second, if you were able to do that, it would defeat the
> >> >> purpose of having security settings in the first place. If your user is to
> >> >> be able to run your macros, they will have to adjust their Excel settings to
> >> >> either permit macros to run directly (not advisable) or to prompt them if it
> >> >> is alright to run macros (better).
> >> >>
> >> >> --
> >> >> Rick (MVP - Excel)
> >> >>
> >> >>
> >> >> "Curt" <(E-Mail Removed)> wrote in message
> >> >> news:6F058A90-3C92-466B-B693-(E-Mail Removed)...
> >> >> > After all this time I have a program that does fine on my comp. When I put
> >> >> > it
> >> >> > on another it says go to online help for macros enable. On my comp when I
> >> >> > open it asks to enable. Is there any code that I can put into excel to
> >> >> > have
> >> >> > it enable when opening or to display screen that allows enable. Have
> >> >> > become
> >> >> > aware of security settings. Assumeing they are high on foreign comp.
> >> >> > Thanks for any assistance.
> >> >>
> >> >>
> >>
> >>
>
>

Assume that means you're sorted out.


Gord

On Fri, 19 Dec 2008 14:36:12 -0800, Curt <(E-Mail Removed)>
wrote:

>My error I was doing it in internet options.
>Thanks
>
>"Gord Dibben" wrote:
>
>> XP and Vista are operating systems and should have no bearing on security
>> options in Excel but I don't run Vista so not sure.
>>
>> You are changing the securioty settings in Excel, right?
>>
>> I never heard of a "medium high" setting but then I have never used Excell
>> 2000 either.
>>
>>
>> Gord
>>
>> On Wed, 17 Dec 2008 23:18:01 -0800, Curt <(E-Mail Removed)>
>> wrote:
>>
>> >Is there any difference in the settings between XP & Vista in security
>> >settings. Both my comp & another are set on medium high. Mine gives a choice
>> >to enable macros the other running Vista with office 2000 same as me asks to
>> >go to online help to enable. I will go back to other comp next week and try
>> >lower settings. As you said medium I hope that is medium high.
>> >Thanks for the input Sure does make a person have confidence when you have
>> >mor knowledgeable one to turn to.
>> >Thanks Again
>> >
>> >"Gord Dibben" wrote:
>> >
>> >> If security is set at high or very high the user will not get the prompt and
>> >> macros will be diabled.
>> >>
>> >> Security set to medium prior to the workbook being opened will raise the
>> >> prompt.
>> >>
>> >> If the workbook is signed and trusted, no prompt will appear but macros will
>> >> be enabled.
>> >>
>> >>
>> >> Gord Dibben MS Excel MVP
>> >>
>> >> On Wed, 17 Dec 2008 10:27:01 -0800, Curt <(E-Mail Removed)>
>> >> wrote:
>> >>
>> >> >My problem is getting to the promp screen to allow macros to run. Does
>> >> >security need to be reset to allow this screen to apear in excel? If so then
>> >> >I will create a doc to explain how to do it. Novices as we are we are getting
>> >> >there.
>> >> >Thanks for assistance
>> >> >
>> >> >"Rick Rothstein" wrote:
>> >> >
>> >> >> You cannot force a system with "high security settings" to run your code.
>> >> >> Think about it. First, how would that code run if the security settings stop
>> >> >> code from running? Second, if you were able to do that, it would defeat the
>> >> >> purpose of having security settings in the first place. If your user is to
>> >> >> be able to run your macros, they will have to adjust their Excel settings to
>> >> >> either permit macros to run directly (not advisable) or to prompt them if it
>> >> >> is alright to run macros (better).
>> >> >>
>> >> >> --
>> >> >> Rick (MVP - Excel)
>> >> >>
>> >> >>
>> >> >> "Curt" <(E-Mail Removed)> wrote in message
>> >> >> news:6F058A90-3C92-466B-B693-(E-Mail Removed)...
>> >> >> > After all this time I have a program that does fine on my comp. When I put
>> >> >> > it
>> >> >> > on another it says go to online help for macros enable. On my comp when I
>> >> >> > open it asks to enable. Is there any code that I can put into excel to
>> >> >> > have
>> >> >> > it enable when opening or to display screen that allows enable. Have
>> >> >> > become
>> >> >> > aware of security settings. Assumeing they are high on foreign comp.
>> >> >> > Thanks for any assistance.
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>

Thanks much will be trying other machine this weekend
Thanks again

"Gord Dibben" wrote:

> Assume that means you're sorted out.
>
>
> Gord
>
> On Fri, 19 Dec 2008 14:36:12 -0800, Curt <(E-Mail Removed)>
> wrote:
>
> >My error I was doing it in internet options.
> >Thanks
> >
> >"Gord Dibben" wrote:
> >
> >> XP and Vista are operating systems and should have no bearing on security
> >> options in Excel but I don't run Vista so not sure.
> >>
> >> You are changing the securioty settings in Excel, right?
> >>
> >> I never heard of a "medium high" setting but then I have never used Excell
> >> 2000 either.
> >>
> >>
> >> Gord
> >>
> >> On Wed, 17 Dec 2008 23:18:01 -0800, Curt <(E-Mail Removed)>
> >> wrote:
> >>
> >> >Is there any difference in the settings between XP & Vista in security
> >> >settings. Both my comp & another are set on medium high. Mine gives a choice
> >> >to enable macros the other running Vista with office 2000 same as me asks to
> >> >go to online help to enable. I will go back to other comp next week and try
> >> >lower settings. As you said medium I hope that is medium high.
> >> >Thanks for the input Sure does make a person have confidence when you have
> >> >mor knowledgeable one to turn to.
> >> >Thanks Again
> >> >
> >> >"Gord Dibben" wrote:
> >> >
> >> >> If security is set at high or very high the user will not get the prompt and
> >> >> macros will be diabled.
> >> >>
> >> >> Security set to medium prior to the workbook being opened will raise the
> >> >> prompt.
> >> >>
> >> >> If the workbook is signed and trusted, no prompt will appear but macros will
> >> >> be enabled.
> >> >>
> >> >>
> >> >> Gord Dibben MS Excel MVP
> >> >>
> >> >> On Wed, 17 Dec 2008 10:27:01 -0800, Curt <(E-Mail Removed)>
> >> >> wrote:
> >> >>
> >> >> >My problem is getting to the promp screen to allow macros to run. Does
> >> >> >security need to be reset to allow this screen to apear in excel? If so then
> >> >> >I will create a doc to explain how to do it. Novices as we are we are getting
> >> >> >there.
> >> >> >Thanks for assistance
> >> >> >
> >> >> >"Rick Rothstein" wrote:
> >> >> >
> >> >> >> You cannot force a system with "high security settings" to run your code.
> >> >> >> Think about it. First, how would that code run if the security settings stop
> >> >> >> code from running? Second, if you were able to do that, it would defeat the
> >> >> >> purpose of having security settings in the first place. If your user is to
> >> >> >> be able to run your macros, they will have to adjust their Excel settings to
> >> >> >> either permit macros to run directly (not advisable) or to prompt them if it
> >> >> >> is alright to run macros (better).
> >> >> >>
> >> >> >> --
> >> >> >> Rick (MVP - Excel)
> >> >> >>
> >> >> >>
> >> >> >> "Curt" <(E-Mail Removed)> wrote in message
> >> >> >> news:6F058A90-3C92-466B-B693-(E-Mail Removed)...
> >> >> >> > After all this time I have a program that does fine on my comp. When I put
> >> >> >> > it
> >> >> >> > on another it says go to online help for macros enable. On my comp when I
> >> >> >> > open it asks to enable. Is there any code that I can put into excel to
> >> >> >> > have
> >> >> >> > it enable when opening or to display screen that allows enable. Have
> >> >> >> > become
> >> >> >> > aware of security settings. Assumeing they are high on foreign comp.
> >> >> >> > Thanks for any assistance.
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
>