Sounds like you security is set to High in Tools=Macro=Security
'
Set it to medium.

Generally you don't call a workbook_open event. You define the event in the
ThisWorkbook Module of the workbook and the action of opening the workbook
causes it to fire.

http://www.cpearson.com/excel/events.htm
Chip Pearson's page on event.s

--
Regards,
Tom Ogilvy

"Marjie" wrote in message
...
I have just created a macro in an excel workbook. I recorded the macro,
named
it, was able to edit it and run it. However, when I close the workbook
and
then open it again, my macro has become disabled. I get an error message
which says:
The macros in this project are disabled. Please refer to the online help
of
the host application to determine how to enable macros. I am concerned
that
I caused a problem as I was trying to create an open event macro. I
created
a macro that I called Workbook_Open. Would this be why I am having
problems.
I started over with a new workbook, but I'm getting the same problems.