Currently when the user uses a macro I save a copy of the workbook with the
sheet name imbedded in the workbook name. This is to indicate to me what
sheet the user was editing when the macro was run. example below:
workbook name saved as Sales 09-2009 (sheet1).xls.

Is there a way just to save the sheet they were working on. It would have to
be copied as values for this save only so I think I would have to first copy
the sheet to a new sheet as values. And then After the saving has completed
I would want the new sheet deleted from the workbook.

I hope I made myself clear enough on this if not I will give better detail.


--
Thank You in Advance
Ed Davis