ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Suppress Save Dialog Box (https://www.excelbanter.com/excel-programming/339334-suppress-save-dialog-box.html)

r wilcox

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

Dave Peterson

Suppress Save Dialog Box
 
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

r wilcox wrote:

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


--

Dave Peterson

Tom Ogilvy

Suppress Save Dialog Box
 
If you specify a binary transfer they shouldn't.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
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

r wilcox wrote:

How do I suppress the save dialog box when exiting the workbook and

force the
workbook to run another procedure instead?


--

Dave Peterson




Dave Peterson

Suppress Save Dialog Box
 
I bet you meant that other thread!

Tom Ogilvy wrote:

If you specify a binary transfer they shouldn't.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
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

r wilcox wrote:

How do I suppress the save dialog box when exiting the workbook and

force the
workbook to run another procedure instead?


--

Dave Peterson


--

Dave Peterson

Tom Ogilvy

Suppress Save Dialog Box
 
Yep. Guess I had the wrong one highlighted <blush

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
I bet you meant that other thread!

Tom Ogilvy wrote:

If you specify a binary transfer they shouldn't.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
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

r wilcox wrote:

How do I suppress the save dialog box when exiting the workbook and

force the
workbook to run another procedure instead?

--

Dave Peterson


--

Dave Peterson





All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com