Macro not getting called

[philky001]

I have a macro that is giving this error when runnning:

"cannot run the macro - the macro may not be available in this workbook or all macros may be disabled."

an error occurred initializing the VBA libraries 40040

 

[scott_n_phnx]

I had one similar to this recently. For your macro, when you built it, did you build it in your PERSONAL and it now resides in a workbook? It is likely that you have a reference that needs to be enabled (VB Editor-->Tools-->References). It probably needs to have one of the libraries enabled. It depends on what your macro is doing. These are dependent on your project. So each workbook would need it enabled to run it for that workbook.