View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Martin[_2_] Bill Martin[_2_] is offline
external usenet poster
 
Posts: 105
Default Macro Location Problem

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