Thread: Shared VBA code between workbooks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vindaloo[_8_] Vindaloo[_8_] is offline
external usenet poster
  
Posts: 1
Default Shared VBA code between workbooks

Since creating this thread I've done the following:

Removed the module from the original workbook and saved it as an XLA.
Loaded this XLA using Tools -- Add-ins
Added a reference to the XLA Project so that the original workbook can
use the subs / functions in the XLA.

Does this sound about right before I modify everyone's timesheet to use
the new add-in?

Thanks,
Vindaloo


--
Vindaloo
------------------------------------------------------------------------
Vindaloo's Profile: http://www.excelforum.com/member.php...o&userid=32634
View this thread: http://www.excelforum.com/showthread...hreadid=574131

Reply With QuoteReply With Quote