Macro Location Problem

[Bill Martin]

My system is set up with a Library.xls file (XLStart folder) that opens
automatically when I startup Excel. I keep various macros in it which I use
broadly.

Something apparently changed in my Excel settings though. I can no longer
access macros in the Library file from other workbooks. The compile will fail
saying that it can't find that SUB name anywhere. Yet the Library workbook is
indeed open and I can still use its macros from within the Library file.
Apparently the scope has been restricted on the Library macros somehow.

Does anyone recognize what I need to touch to restore normal operation?

Thanks...

Bill

 

[Bill Martin]

My system is set up with a Library.xls file (XLStart folder) that opens
automatically when I startup Excel. I keep various macros in it which I use
broadly.

Something apparently changed in my Excel settings though. I can no longer
access macros in the Library file from other workbooks. The compile will fail
saying that it can't find that SUB name anywhere. Yet the Library workbook is
indeed open and I can still use its macros from within the Library file.
Apparently the scope has been restricted on the Library macros somehow.

Does anyone recognize what I need to touch to restore normal operation?

Thanks...

Bill

-------------

Problem resolved. VBE defaults with all project names to be identical which
caused some Reference problems. Making distinct project names fixed all.

Bill