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

May Your Christmass be as great as mine. Thanks to all for the help. All most
2 years of working I now have a program that can help many. Without all of
you I could have never accomplished this effort.
Thanks Again Merry Christmass

"Gord Dibben" wrote:

Assume that means you're sorted out.


Gord

On Fri, 19 Dec 2008 14:36:12 -0800, Curt
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
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
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" wrote in message
...
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.

Good to hear that.

Merry Christmas

On Sat, 20 Dec 2008 21:35:00 -0800, Curt
wrote:

May Your Christmass be as great as mine. Thanks to all for the help. All most
2 years of working I now have a program that can help many. Without all of
you I could have never accomplished this effort.
Thanks Again Merry Christmass

"Gord Dibben" wrote:

Assume that means you're sorted out.


Gord

On Fri, 19 Dec 2008 14:36:12 -0800, Curt
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
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
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" wrote in message
...
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.