Would it make sense to save just the worksheets without all the code?

[brucemc777]

Wondering if I have missed something obvious - with a large project, well say around or over 10,000 lines of vba, if it would make sense & save time upon a save for update purposes to somehow restrict the save to just "data" and not be re-saving all of the code each time. Seems kind of useless, but I don't have the knowledge to just start running down that path...

Thoughts?

Thank-You!

[TMS]

It would be possible to put all the code in a stand alone workbook and keep the data in a separate workbook. The code workbook would open the data workbook, process the data, save it and close it.

That said, Event handling would have to stay with the workbook.

Bit difficult to be specific without knowing what your 10,000 lines of code do.