Check your settings at ToolsMacroSecurity. Set to Medium.

Ed

<Susan Hayes wrote in message
...
I have written some If statements on VBA, that work well on my home
computer, however when I transferred them (by disk) to my work
computer they don't function at all. I am using the identical version
of Excel 2000 at both places.
The following message came up on a pop-up window, while I was
attempting it at work:

"The macros in this project are disabled. Please refer to the online
help or documentation of the host application to determine how to
enable macros."

Is there some setting I can select or click on Excel to make it work?

Thank you in advance,

Lisa