Backing up Code

[ccordner]

Is it possible to backup all the modules, userforms etc. in one file/package easily?

I've just had Excel refuse to save on me. It has saved the workbook, but all my code and forms have disappeared. Fortunately, I have a reasonably recent copy of the worksheet, so I have only lost a day or two's work but it's frustrating.

Ideally, I want to export all the modules and userforms to one zip/file and be able to import them to another spreadsheet (a master copy of the one I'm using) to make improvements.

 

[MrKowz]

You can export the modules by right clicking on them and clicking "Export Module". It will save them as a .bas file that you can import at a later time.

 

[shg]

CodeCleaner will do this in one fell swoop.

 

[ccordner]

Thanks for that, I shall have a look at the code cleaner.

Just that heart-attack moment when I opend the Visual Basic Editor and saw nothing!

Chris.