| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
skipping pop up box for saving changes when closing a file
In my macro I open and close several files. One of them I dont want to save
the changes I have done to the file. I thought the following was a way to elimate the "Do you want to save your changes" pop up box that shows up when I close the file.....but for some reason excel does not agree with me. Thanks for the help Application.DisplayAlerts = False Workbooks(Top25Report).Close Savechanges:=False Application.DisplayAlerts = True |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
skipping pop up box for saving changes when closing a file
thisworkbook.saved = true
Hope this helps... "Tony" wrote: In my macro I open and close several files. One of them I dont want to save the changes I have done to the file. I thought the following was a way to elimate the "Do you want to save your changes" pop up box that shows up when I close the file.....but for some reason excel does not agree with me. Thanks for the help Application.DisplayAlerts = False Workbooks(Top25Report).Close Savechanges:=False Application.DisplayAlerts = True |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving and closing | Setting up and Configuration of Excel | |||
| Saving and Closing | Excel Worksheet Functions | |||
| auto saving & closing file | Excel Worksheet Functions | |||
| How to code on Macro on saving and closing a file? | Excel Worksheet Functions | |||
| closing a file without saving | Excel Programming | |||
Linear Mode
