Hi

I have a spreadsheet which uses a number of macros and forms to control
entering of data relating to a product. Each new product requires a new
instance of the spreadsheet so I open a 'Master' copy and then save with a
new name.
Creating copies in this way gives a problem if I edit any of the code or
form structure as I have to go back through each instance and import the
affected modules and forms previously exported from the MASTER.

So. is it possible to have my code loaded in separate file and access this
remotely from the spreadsheets?
OR
Create a macro in the spreadsheet which will delete all current modules
(apart from the one containing itselr) and froms then import the code from an
external file? In other words automate the task I am having to do.