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?

Keep the macro(s) in one workbook and the data you work on in another
workbook.

HTH. Best wishes Harald


"davegb" skrev i melding
ups.com...
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?

Harald Staff wrote:
Keep the macro(s) in one workbook and the data you work on in another
workbook.

HTH. Best wishes Harald

Was afraid someone was going to say that! I guess no one at MS who set
this all up ever wrote a complex program that needed destructive
testing.
Thanks for your reply!

Start another workbook.
Drag the module from one project to another.



davegb wrote:

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?

--

Dave Peterson

Dave Peterson wrote:
Start another workbook.
Drag the module from one project to another.


Thanks, Dave! Foolish me, I thought it was a 21st century development
tool! :)

I don't know how you could beat that speed.

davegb wrote:

Dave Peterson wrote:
Start another workbook.
Drag the module from one project to another.


Thanks, Dave! Foolish me, I thought it was a 21st century development
tool! :)

--

Dave Peterson