When I removed the reference to VBA extensibility, I got a different error
than what you reported - a constant (vbext_ct_StdModule) not defined. It
always pays to use Debug / Compile on your code to find errors like that.
Try setting your Tools / Options, General Tab "Compile on demand" and you
will get better error messages.

Bernie


"Cap Kirk" wrote in message
...
I found the culprit.

The "MS VBA EXTENSIBILITY 5.3 " library was NOT referenced.
I went to the VBA editor (EXCEL=Tools=Macros=VBA Editor) and there
again:
Tools=References and checked the library.

Now the macro is alive again. Thanks to everybody that tried to help me.

Cap Kirk