"save changes pop up"
 

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.

"save changes pop up"
 

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.

--
Regards,
Tom Ogilvy

"Michelle" wrote in message
...
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.

"save changes pop up"
 

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 ToolAddins.

-----Original Message-----
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.
.