Hi
Tools/Macros/Security setting should be Medium
Alok

"jvoortman" wrote in message
om...
I was working in an Excel worksheet. Closed it while I went out for a
while. Opened it up on my return to continue working in it but now
when I try and use the Macro I had set up for pasteing "text only", I
get an error message which redas as follows:
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. I tried the help files in Excel but I couldn't find any
solution. Please help (ps..thanks in advance for any help offered). I
did try to go to ToolsMacrosSecurity, where I lowered the setting
but that made no difference. I am using Microsoft Office XP Pro, and I
am using Office 2000 version of Excel.