Replacing old vba code with new help

[Tezzies]

My existing project is to create student result spreadsheets. Every now and again a fault is found and I have to enter each individual workbook (thats still in use)and edit the code.

I know I can export import but have any of you vba guru 's created something quicker.

There are about 5 sheets 10 modules and 5 forms per workbook.

Many thanks

[Bob Phillips]

Couldn't you just copy the whole workbook?

[Tezzies]

The exististing workbook has conditional formatting and scores already entered. Its one or the other really , move the code or move the data.

[Bob Phillips]

No, have a template workbook with the formats and code etc., but no data, when you need a new one, copy that.