SavingExcelChanges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a question about saving Excel changes
I have a macro that when activated by an operator copies data from worksheet A to worksheet D
How can I automatically save the copied data in Worksheet D in case the operator hits the x o
closes workbook without saving changes

thank
 
Hi Super Jas
Thanks for the help. This works very well.
Mike

----- SuperJas wrote: -----

Hi Mike,

You'll need to add this line of code after the pasting has been done:
 
Back
Top