Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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





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
How can I suppress the enable macros and save changes messages? Ron in Walnut Creek Excel Worksheet Functions 4 October 29th 09 08:36 PM
Suppress dialog from regserver command mdullni1 via OfficeKB.com Excel Discussion (Misc queries) 3 April 30th 08 07:51 PM
how to suppress office assistance dialog Ormy Excel Discussion (Misc queries) 0 January 20th 06 09:49 AM
How-To suppress a warning dialog James Excel Programming 2 August 11th 04 08:36 PM
Suppress dialog while opening a write protected Excel document from VBS Stefan[_7_] Excel Programming 1 February 17th 04 12:47 PM


All times are GMT +1. The time now is 11:21 PM.

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

About Us

"It's about Microsoft Excel"