Macros disabled message

[Guest]

Sometimes I get this "Macros Disabled", but sometimes I
don't. I'm getting it right now, and it's driving me
crazy, how do I get rid of it?

 

[coyote_5]

I need to know this also. I'm working in a large excel worksheet that
designed. The only macro is one assigned to a drop down box wit
selects fiscal quarter. everytime I input data into a new cell, I ge
a message stating macros are disabled. I can not find informatio
anywhere as to how to enable them!!

Help

 

[Gord Dibben]

I would assume your Tools>Options>Security is at "High".

Workbooks with unsigned macros will get the "disabled" message.

Those that have been signed will open with no message and be enabled.

Lower your security level to "medium" and you will only get the prompt to
enable or disable.

If for your own use on your computer, see help on certificates which leads you
to using SelfCert which can be used to create a digital certificate.

Gord Dibben Excel MVP