Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 550
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do certain worksheets ALWAYS ask if I want to save them when closing them? glbecker12@$sbcglobal.net Excel Discussion (Misc queries) 5 July 2nd 08 04:46 PM
Closing but doesn't ask to save TJAC Excel Discussion (Misc queries) 1 November 2nd 06 09:31 PM
why it never prompt to save after closing lightstraight Setting up and Configuration of Excel 1 August 21st 06 12:05 PM
Save files before closing MasterP Excel Discussion (Misc queries) 1 December 30th 05 08:13 PM
Auto Save on closing AJM1949 Excel Discussion (Misc queries) 3 September 21st 05 10:03 AM


All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"