View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marvin Marvin is offline
external usenet poster
 
Posts: 71
Default Reference Errors with Distribution of excel sheets with macros

I developed an excel mailing cost simulator using standard excel 2003 macro
support. Some of the users are getting the "can't find project or library"
message when the auto open macro starts. It appears that the calendar module
is missing from the reference table at the very least. I added a trap to the
code to avoid the debug screen for those users but they cannot use the system
until I get a solution.

Questions;
1. How can I reliably distrubute excel work without worry about individual
stations.
2. What do I do to correct the missing calendar module at the stations
complaining.