Posted to microsoft.public.excel.programming

Stuart[_5_] Stuart[_5_] is offline

external usenet poster

Posts: 413

Workbook Before_Close question

If user clicks the little 'x' in top right corner, then
I believe I can trap this with the Before_Close Event.
prior to the book closing.

Providing code has not saved the activeworbook
prior to this point, how do I Close without Saving
changes, please?

Regards.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.710 / Virus Database: 466 - Release Date: 23/06/2004

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
Wierd one concerning Before_Close and OnTime	Antonio	Excel Discussion (Misc queries)	14	June 9th 06 05:33 PM
Workbook Name question	Stuart[_5_]	Excel Programming	3	April 10th 04 07:35 PM
Before_Close problem	Roberto[_4_]	Excel Programming	4	November 15th 03 10:49 AM
Question for Experts: Opening workbook with workbook references	Chris	Excel Programming	0	September 11th 03 07:05 PM
Auto_Open & Before_Close	John Wilson	Excel Programming	0	August 6th 03 09:04 PM

All times are GMT +1. The time now is 06:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us