"save changes pop up"

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have a program that will reset different workbooks but
each time you hit reset you have to click the save changes
to XX file button 20 times. Is there any way to make it
just save changes without prompting you.
 
ActiveWorkbook.close Savechanges:=True

would be one guess. Reset is not a verb for workbooks in Excel, so what
you mean by that is not self defining.
 
hi,
not sure what you mean by "reset". new term for me.
but save without prompting. use autosave. it is an xl addin
access by Tool>Addins.
 
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

Mid column sum formulas with varied ranges to sum 17
MACRO TO POP UP SAVE AS WINDOW 1
VBA editor doesn't prompt to save changes, doesn't save 3
Saving a Workbook cause's Error's 7
Message still appears with DisplayAlerts = False & SaveChanges:=Fa 1
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
SAVE AS/ GET SAVE AS/ 1
Macro to open a workbook as read only 2

Back
Top