View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Forms and Modules

If you create a reference to the second workbook it will open when the first
workbook is opened. You can not close it until the first workbook is
closed.

--
Regards,
Tom Ogilvy

scrabtree23 wrote in message
...
Is there a way I can get an open Workbook to utilize the
Forms and Modules from a closed Workbook?

Of, if that won't work, is there a way I can get a second
Workbook to automatically open as the 1st Workbook opens?

My problem is that I have a Workbook that is too large to
practically utilize across a network or to mail.
Therefore, I am looking for a way to store the forms and
modules some place else without losing the funcionality of
the program???

SDC