macros won't work stupid security

[mike]

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.

 

[Alan]

Have you tried 'Tools' > 'Macros' >'Security' and set the secutity level to
'Medium'?
Regards,
Alan.

 

[mike]

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

 

[Alan]

Oh sorry, I'm on 2003, I couldn't say if it's there or not in 2007,
Regards,
Alan.

 

[robert morris]

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

Bob

 

[mike]

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?

 

[mike]

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.

 

[Alan]

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.