Posted to microsoft.public.excel.programming

[email protected] YoureNotAtHomeNow@googlemail.com is offline

external usenet poster

Posts: 17

Disable Alert

On May 6, 8:37*pm, Per Jessen wrote:
Hi

Excel will always prompt the user to save an unsaved file before
closing it.

Another solution to close without saving:

ThisWorkbook.Close SaveChanges:=False

Regards,
Per

Thanks. *It worked. *Any ideas why my first try didn't work?-- Hide quoted text -

- Show quoted text -

Thanks, All.

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
Disable Macro Alert	[email protected]	Excel Discussion (Misc queries)	2	September 2nd 11 08:49 PM
Can you disable the macro security alert?	Elceller in distress[_2_]	Excel Programming	4	August 1st 06 10:36 PM
Disable the alert	hurriance[_9_]	Excel Programming	0	June 30th 06 08:59 AM
Disable Link Alert	Otto Moehrbach	Excel Programming	1	June 14th 06 10:15 PM
Disable alert message when merging cells??	yung	Excel Programming	1	March 10th 05 02:57 AM

All times are GMT +1. The time now is 05:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us