Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing the save changes box
CrazySultana,
Try Application.DisplayAlerts = False just before the "save" in your code. John "CrazySultana" wrote in message ... Hello :) I have written a macro that opens up a file (1), changes a few things and copies the data to an already open file. The macro then proceeds to close file 1, and the save changes dialogue box pops up. How can I make my code automatically select no or prevent that box from popping up? Thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do certain worksheets ALWAYS ask if I want to save them when closing them? | Excel Discussion (Misc queries) | |||
Closing but doesn't ask to save | Excel Discussion (Misc queries) | |||
why it never prompt to save after closing | Setting up and Configuration of Excel | |||
Save files before closing | Excel Discussion (Misc queries) | |||
Auto Save on closing | Excel Discussion (Misc queries) |