| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
| "CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
| In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
| "Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
| how to change default file name in "save as" or "save" | Excel Programming | |||
Linear Mode
