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 Mike

You'll need to add this line of code after the pasting has been done
 
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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel crashes and restarts when accessing newly created worksheet 2
Problem with a macro 1
error trying to sort data 4
Why do charts disappear? 2
Excel Highlighting duplicates 0
Message still appears with DisplayAlerts = False & SaveChanges:=Fa 1
Need Macro... 8

Back
Top