Error Message

F

Fernanda Jones

Every time I enter any information in a cell I get this
message:

"The macros in this project are disabled..."

How do I fix it - I don't understand the instructions.
Thank you.
 
J

JulieD

Hi Fernanda

basically it seems that the workbook contains some VBA code (macros) which
has been writen to run when you enter information into a cell, as the macros
have been disabled (default setting in Excel) then they can't run as the
author of the workbook designed them to.

IF you know who created the workbook and you are sure that the macro code in
it is something you want to run then if you close the workbook (leave excel
open) choose tools / macros / security and change it to medium and then open
the workbook again and click on the enable macros button then the workbook
will work as designed.

However if this is happening on all your excel workbooks or you do not know
what the macros are designed to do then it is not a good idea to enable
macros as they can run viruses (virii?).

Regards
JulieD
 
F

Fernanda Jones

JulieD,

I am the one who is creating this - it is just a simple
program that will help us track our business data better.
I don't even know what a macro is or set one up myself. I
just started from scratch.

Does that give you any information that is helpful?
 
J

JulieD

Hi Fernanda

others in the ng might have a better idea than me if this is a known
problem, but if it was happening to me i would choose Tools / Macro / Macros
from the menu and down the bottom of the screen change the macros in drop
down to "This workbook" and then i would see if anything appeared in the
list above .. .if it does and you're creating the workbook and haven't put
anything in here, i would click on each one in turn & press the Delete
button

If there is nothing shown when you do the above, then change the drop down
to Personal.xls (if shown) and see what's there ... if there is anything i
would be a bit cautious about deleting ... i would probably press the EDIT
button (this takes you into the VB Editor window) and see if anything in
green tells me why it is there (to close this window just use the X on the
top right) ... if it appears to be junk or you are the only person who uses
that computer then delete it, or type a ' in front of each line (in the VB
Editor window) - which will turn it all green and then if it belongs to
anyone else you can "discuss" it with them when they complain their macros
aren't working.

Hope this helps - let us know how you go
Cheers
JulieD
 
G

Gord Dibben

Fernanda

Click on Help then "About Excel".

"Disabled items" button next.

See anything there that may be diabled?

If so, try to re-enable or post back with any findings.

Gord Dibben Excel MVP
 
F

Fernanda Jones

I figured it out...
CAUSE
This problem occurs when you run any of the sample macros
in the Samples.xls file included with Microsoft Excel or
Microsoft Office and you have set the security level for
macros to High.
RESOLUTION
To run the sample macros in the Samples.xls workbook, set
the security level for macros to Medium or Low. To change
the macro security level, follow these steps:
If the Samples.xls file is open, close it.
On the Tools menu, point to Macro and click Security.
In the Security dialog box, click the Security Level tab.
Click Medium and then click OK.
Open Samples.xls. When prompted whether to enable or
disable macros, click Enable Macros.
 
G

Gord Dibben

Thanks for the feedback Fernanda.

Gord

I figured it out...
CAUSE
This problem occurs when you run any of the sample macros
in the Samples.xls file included with Microsoft Excel or
Microsoft Office and you have set the security level for
macros to High.
RESOLUTION
To run the sample macros in the Samples.xls workbook, set
the security level for macros to Medium or Low. To change
the macro security level, follow these steps:
If the Samples.xls file is open, close it.
On the Tools menu, point to Macro and click Security.
In the Security dialog box, click the Security Level tab.
Click Medium and then click OK.
Open Samples.xls. When prompted whether to enable or
disable macros, click Enable Macros.
Click to expand...
 
P

Patty

Fernanda,

Sometimes deleting a Macro doesn't quite work and causes
similar error messages. Go to Tools, To Macro, To Visual
Basic. You can delete the module that is causing the
error. Make sure you are deleting the correct module.

Patty
 
Top