Saving macros
Is there any way to save a macro in progress other than exporting it or
saving the spreadsheet it's associated with? What, if anything, does
the "File, Save" or the Save icon in the VBE do?
The macro I'm working on hoses up the spreadsheet, so I'd like to close
without saving the worksheet, but I lose my work on the macro if I do.
The only way I know to avoid this is to export the macro, then import
it after I close the spreadsheet without saving it. Is there an easier
way?
|