Posted to microsoft.public.excel.programming

Scott buckwalter Scott buckwalter is offline

external usenet poster

Posts: 7

Disable Save Workbook popup

Found it.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Sub

Works.

"Scott buckwalter" wrote:

I have a workbook that I do not want the user prompted to save whenever they
close it. Is there a way I can disable that popup? Maybe override the
Workbook_OnClose event?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Can you disable the save function from a shared workbook	jcallahan	Excel Discussion (Misc queries)	2	April 3rd 07 02:11 AM
Enable & Disable Macro popup disappear	Wayne	Excel Programming	5	November 11th 04 06:20 PM
Disable popup menu	helmekki[_47_]	Excel Programming	0	October 28th 04 01:32 AM
Disable popup menu	helmekki[_46_]	Excel Programming	1	October 27th 04 08:29 PM
Disable Save As just for opened workbook	Daniel Wright	Excel Programming	0	July 25th 03 09:20 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us