Disabled macros

M

MileHigh

Our company just upgraded to Windows XP and running Excel 2000.
Yesterday I wrote some new macros and saved them, today when I try t
run them I get the message:
"The macros in this project are disabled."
I cannot find when or how to enable them. Can anyone help?
 
J

Jan Karel Pieterse

Hi MileHigh,
"The macros in this project are disabled."
I cannot find when or how to enable them. Can anyone help??
Click to expand...

Excel is set to high macro security. Set it to medium so you can choose
whether to enable them or not:

Tools, Macros, security.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
P

Paul B

MileHigh, take a look under tools, macro, security and see what the setting
is, if it is set to high the macros will be disabled automatically

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
G

Gord Dibben

If this is not the case, hit the Help button and "About Excel". Check to see
if anything is listed under "disabled items".

If anything there, make sure you security is not set at "high", then try to
"enable".

Gord Dibben Excel MVP
 
Top