Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I got this code from the archives to save the workbook: ThisWorkbook.Save
When I'd recorded saving the workbook earlier, the code was very similar, ActiveWorkbook.Save. The difficulty is that after using either macro, yes, I do see the saving message at the bottom of the workbook that alerts me to the saving process but when I immediately go to close the workbook, I'm still prompted to save it. Yet when I click on FILE SAVE, I close the workbook and the prompt doesn't come up. Is there better code to use rather than either workbook.save that will really save the file? TIA. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Save file before closing" | Excel Discussion (Misc queries) | |||
Protect "Copy" and "Save As" changes to workbook | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
excel 02 always asks "save changes?" when closing unaltered file | Excel Discussion (Misc queries) | |||
save and restore "Workbook Menu Bar" & "Cell" menus | Excel Programming |