If the problem is just with one workbook it might be worth trying Code
Cleaner

http://www.appspro.com/Utilities/CodeCleaner.htm

This is a quote from the site:

"During the process of creating VBA programs a lot of junk code builds up in
your files. If you don't clean your files periodically you will begin to
experience strange problems caused by this extra baggage"

(with thanks to Chip Pearson whom I first saw mention this utility back in
February)

HTH


"Spike" wrote in message
...
I have a workbook with various macros, class modules etc. Everything has
worked fine until recently when the "Open" event macro does not fire up
anymore.. Also a macro that refers to named ranges fails as the named
ranges
are no longer recognised; if this macro is stopped (not paused) then the
named ranges show on the relevant spreadsheet.

The Vba compiles ok and all relevant References are ticked in Tools\Refs.

If anyone has any ideas I will be very pleased to hear as I am loathe to
rebuild the complete workbook. I guess the answer is very basic but it
has
eluded me to date!

--
with kind regards

Spike