macros won't work stupid security
 

I coded a simple macro to to make a print button and clear some fields etc.
no links or anything. When I sent the sheet to the respective user the macro
would not run. When I tried to manually start it it said it could not because
of the trust center settings. I went to the trust center settings and enabled
all macros (and almost everything else trying to get this to work). opened
the file . . . . nothing. tried to manually run again and it told me to
enable from the drop down when I open the file. Closed the file, reopened . .
.. no drop down. Found a setting somewhere that disable the dropdown (huh?).
Enabled it. closed the file . .re opened. clicked the enable button and I
don't even get the option to enable. It tells me for security reasons that I
can't have that option. What the heck gives? Do I need to reboot my computer
or start working with a non-microsoft program or what? Are there yet more
security settings I'm not seeing? This is getting to be VERY frustrating.

macros won't work stupid security
 

Have you tried 'Tools' 'Macros' 'Security' and set the secutity level to
'Medium'?
Regards,
Alan.
"mike" wrote in message
...
I coded a simple macro to to make a print button and clear some fields etc.
no links or anything. When I sent the sheet to the respective user the
macro
would not run. When I tried to manually start it it said it could not
because
of the trust center settings. I went to the trust center settings and
enabled
all macros (and almost everything else trying to get this to work). opened
the file . . . . nothing. tried to manually run again and it told me to
enable from the drop down when I open the file. Closed the file, reopened
. .
. no drop down. Found a setting somewhere that disable the dropdown
(huh?).
Enabled it. closed the file . .re opened. clicked the enable button and I
don't even get the option to enable. It tells me for security reasons that
I
can't have that option. What the heck gives? Do I need to reboot my
computer
or start working with a non-microsoft program or what? Are there yet more
security settings I'm not seeing? This is getting to be VERY frustrating.

macros won't work stupid security
 

I am using excel 2007 and I don't think there's such a menu . . . at least I
can't find it.

"Alan" wrote:

Have you tried 'Tools' 'Macros' 'Security' and set the secutity level to
'Medium'?
Regards,
Alan.
"mike" wrote in message
...
I coded a simple macro to to make a print button and clear some fields etc.
no links or anything. When I sent the sheet to the respective user the
macro
would not run. When I tried to manually start it it said it could not
because
of the trust center settings. I went to the trust center settings and
enabled
all macros (and almost everything else trying to get this to work). opened
the file . . . . nothing. tried to manually run again and it told me to
enable from the drop down when I open the file. Closed the file, reopened
. .
. no drop down. Found a setting somewhere that disable the dropdown
(huh?).
Enabled it. closed the file . .re opened. clicked the enable button and I
don't even get the option to enable. It tells me for security reasons that
I
can't have that option. What the heck gives? Do I need to reboot my
computer
or start working with a non-microsoft program or what? Are there yet more
security settings I'm not seeing? This is getting to be VERY frustrating.

macros won't work stupid security
 

Oh sorry, I'm on 2003, I couldn't say if it's there or not in 2007,
Regards,
Alan.
"mike" wrote in message
...
I am using excel 2007 and I don't think there's such a menu . . . at least
I
can't find it.

"Alan" wrote:

Have you tried 'Tools' 'Macros' 'Security' and set the secutity level
to
'Medium'?
Regards,
Alan.
"mike" wrote in message
...
I coded a simple macro to to make a print button and clear some fields
etc.
no links or anything. When I sent the sheet to the respective user the
macro
would not run. When I tried to manually start it it said it could not
because
of the trust center settings. I went to the trust center settings and
enabled
all macros (and almost everything else trying to get this to work).
opened
the file . . . . nothing. tried to manually run again and it told me to
enable from the drop down when I open the file. Closed the file,
reopened
. .
. no drop down. Found a setting somewhere that disable the dropdown
(huh?).
Enabled it. closed the file . .re opened. clicked the enable button and
I
don't even get the option to enable. It tells me for security reasons
that
I
can't have that option. What the heck gives? Do I need to reboot my
computer
or start working with a non-microsoft program or what? Are there yet
more
security settings I'm not seeing? This is getting to be VERY
frustrating.

macros won't work stupid security
 

It is on the Developer Tab on the Ribbon. Macro Security.

Bob


"mike" wrote:

I am using excel 2007 and I don't think there's such a menu . . . at least I
can't find it.

"Alan" wrote:

Have you tried 'Tools' 'Macros' 'Security' and set the secutity level to
'Medium'?
Regards,
Alan.
"mike" wrote in message
...
I coded a simple macro to to make a print button and clear some fields etc.
no links or anything. When I sent the sheet to the respective user the
macro
would not run. When I tried to manually start it it said it could not
because
of the trust center settings. I went to the trust center settings and
enabled
all macros (and almost everything else trying to get this to work). opened
the file . . . . nothing. tried to manually run again and it told me to
enable from the drop down when I open the file. Closed the file, reopened
. .
. no drop down. Found a setting somewhere that disable the dropdown
(huh?).
Enabled it. closed the file . .re opened. clicked the enable button and I
don't even get the option to enable. It tells me for security reasons that
I
can't have that option. What the heck gives? Do I need to reboot my
computer
or start working with a non-microsoft program or what? Are there yet more
security settings I'm not seeing? This is getting to be VERY frustrating.

macros won't work stupid security
 

The macros are set to enable all macros in the macro security settings of the
trust center. I still get the popup bar that asks me if I want to enable the
macro when I open the file. When I select "enable macros" I get a message
that says something like the macro settings in the file are set such and I
need to enable them. The only option I get here is "help protect me from this
content" so thats the one I have to choose. there is no other options and I
can't uncheck the selection box (circle). Are there different settings for
macros that are specific to the file?

"robert morris" wrote:


It is on the Developer Tab on the Ribbon. Macro Security.

Bob


"mike" wrote:

I am using excel 2007 and I don't think there's such a menu . . . at least I
can't find it.

"Alan" wrote:

Have you tried 'Tools' 'Macros' 'Security' and set the secutity level to
'Medium'?
Regards,
Alan.
"mike" wrote in message
...
I coded a simple macro to to make a print button and clear some fields etc.
no links or anything. When I sent the sheet to the respective user the
macro
would not run. When I tried to manually start it it said it could not
because
of the trust center settings. I went to the trust center settings and
enabled
all macros (and almost everything else trying to get this to work). opened
the file . . . . nothing. tried to manually run again and it told me to
enable from the drop down when I open the file. Closed the file, reopened
. .
. no drop down. Found a setting somewhere that disable the dropdown
(huh?).
Enabled it. closed the file . .re opened. clicked the enable button and I
don't even get the option to enable. It tells me for security reasons that
I
can't have that option. What the heck gives? Do I need to reboot my
computer
or start working with a non-microsoft program or what? Are there yet more
security settings I'm not seeing? This is getting to be VERY frustrating.

macros won't work stupid security
 

Problem solved. I accidently protected workbook instead of worksheet, which
renders all links and macros inactive.

There is an issue with info reporting in excel, relating to this. There
should be a mention of this effect somewhere in the enable macro/links help
because all the prompts and help tips I read kept only pointing me toward the
trust center settings which was making my head spin as nothing I did there
helped. It would be nice if I could of had a prompt or warning that the
workbook was protected, rather than the erroneous message that it had
something to do with the macro security settings.

"mike" wrote:

The macros are set to enable all macros in the macro security settings of the
trust center. I still get the popup bar that asks me if I want to enable the
macro when I open the file. When I select "enable macros" I get a message
that says something like the macro settings in the file are set such and I
need to enable them. The only option I get here is "help protect me from this
content" so thats the one I have to choose. there is no other options and I
can't uncheck the selection box (circle). Are there different settings for
macros that are specific to the file?

"robert morris" wrote:


It is on the Developer Tab on the Ribbon. Macro Security.

Bob


"mike" wrote:

I am using excel 2007 and I don't think there's such a menu . . . at least I
can't find it.

"Alan" wrote:

Have you tried 'Tools' 'Macros' 'Security' and set the secutity level to
'Medium'?
Regards,
Alan.
"mike" wrote in message
...
I coded a simple macro to to make a print button and clear some fields etc.
no links or anything. When I sent the sheet to the respective user the
macro
would not run. When I tried to manually start it it said it could not
because
of the trust center settings. I went to the trust center settings and
enabled
all macros (and almost everything else trying to get this to work). opened
the file . . . . nothing. tried to manually run again and it told me to
enable from the drop down when I open the file. Closed the file, reopened
. .
. no drop down. Found a setting somewhere that disable the dropdown
(huh?).
Enabled it. closed the file . .re opened. clicked the enable button and I
don't even get the option to enable. It tells me for security reasons that
I
can't have that option. What the heck gives? Do I need to reboot my
computer
or start working with a non-microsoft program or what? Are there yet more
security settings I'm not seeing? This is getting to be VERY frustrating.

macros won't work stupid security
 

Glad you got it sorted, you can protect and unprotect sheets or the workbook
from within the macro code,

ActiveWorkbook.Protect ("Password")
'Your code here
ActiveWorkbook.Unprotect ("Password")

Regards,
Alan.

"mike" wrote in message
...
Problem solved. I accidently protected workbook instead of worksheet,
which
renders all links and macros inactive.

There is an issue with info reporting in excel, relating to this. There
should be a mention of this effect somewhere in the enable macro/links
help
because all the prompts and help tips I read kept only pointing me toward
the
trust center settings which was making my head spin as nothing I did there
helped. It would be nice if I could of had a prompt or warning that the
workbook was protected, rather than the erroneous message that it had
something to do with the macro security settings.

"mike" wrote:

The macros are set to enable all macros in the macro security settings of
the
trust center. I still get the popup bar that asks me if I want to enable
the
macro when I open the file. When I select "enable macros" I get a message
that says something like the macro settings in the file are set such and
I
need to enable them. The only option I get here is "help protect me from
this
content" so thats the one I have to choose. there is no other options and
I
can't uncheck the selection box (circle). Are there different settings
for
macros that are specific to the file?

"robert morris" wrote:


It is on the Developer Tab on the Ribbon. Macro Security.

Bob


"mike" wrote:

I am using excel 2007 and I don't think there's such a menu . . . at
least I
can't find it.

"Alan" wrote:

Have you tried 'Tools' 'Macros' 'Security' and set the secutity
level to
'Medium'?
Regards,
Alan.
"mike" wrote in message
...
I coded a simple macro to to make a print button and clear some
fields etc.
no links or anything. When I sent the sheet to the respective
user the
macro
would not run. When I tried to manually start it it said it could
not
because
of the trust center settings. I went to the trust center settings
and
enabled
all macros (and almost everything else trying to get this to
work). opened
the file . . . . nothing. tried to manually run again and it told
me to
enable from the drop down when I open the file. Closed the file,
reopened
. .
. no drop down. Found a setting somewhere that disable the
dropdown
(huh?).
Enabled it. closed the file . .re opened. clicked the enable
button and I
don't even get the option to enable. It tells me for security
reasons that
I
can't have that option. What the heck gives? Do I need to reboot
my
computer
or start working with a non-microsoft program or what? Are there
yet more
security settings I'm not seeing? This is getting to be VERY
frustrating.