I don't understand what any antivirus software would do to prevent you from
using a template.

Start a new workbook
rename the first worksheet and delete all the others
import this .bas file into the workbook's project
save this file as a template and you're done.

Or you could look at the link that Barb suggested and review the code labeled:
Copy A Module From One Project To Another

Rivers wrote:

THANK YOU but have decided due to the antivirus software and having to
recreate a massive program to use the template version i going to have to
carry on looking

i wasnt looking for the VB editor to write vb i just wanted the editor to
insert a module i had saved in the folder as a .baa file

any further ideas any one?

ps thanks you dave and barb knowing that bit of info i will definatly use in
future packs.

--

Dave Peterson