Suppress Save Dialog Box

Guest · Sep 7, 2005

How do I suppress the save dialog box when exiting the workbook and force the
workbook to run another procedure instead?

Dave Peterson · Sep 7, 2005

There are events that you can tie into. One of them is workbook_beforesave.

You can read more about these kinds of events at Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

Tom Ogilvy · Sep 7, 2005

If you specify a binary transfer they shouldn't.

Dave Peterson · Sep 7, 2005

I bet you meant that other thread!

Tom said:
If you specify a binary transfer they shouldn't.

Tom Ogilvy · Sep 7, 2005

Yep. Guess I had the wrong one highlighted <blush>

Suppressing questions in Excel Macros	1	Feb 3, 2010
suppress compatibility warning dialog during save	2	Jul 13, 2008
Close w/o saving changes	6	Jul 28, 2009
Code corruption problem	1	Oct 2, 2009
suppressing auto-dailog boxes	1	Oct 21, 2005
Suppress File Selection Box	2	Mar 25, 2008
Skip Read Only MsgBox with Save As	6	Mar 17, 2008
Form Unload?	2	Nov 3, 2009

Suppress Save Dialog Box

Guest

Dave Peterson

Tom Ogilvy

Dave Peterson

Tom Ogilvy

Ask a Question

Similar Threads