Posted to microsoft.public.excel.programming

Curt

external usenet poster

Posts: 469

event failing

Have the following code works most of the time. On occasion will not trigger
and asks if you want to save changes. Do not understand why this occionsial
failure.
Thanks for looking
Heres code
Private Sub Workbook_BeforeClose(cancel As Boolean)
'Call catsheetdel
UserForm3.Show False
Call catsheetdel
DoEvents
UserForm3.Hide
ThisWorkbook.Save
End Sub

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
IF statement failing	kimg	Excel Programming	2	July 6th 07 01:20 AM
COUNTA failing?	dpenny	Excel Discussion (Misc queries)	4	July 24th 06 06:52 PM
My formulas are failing!	Excel_Orator	Excel Discussion (Misc queries)	3	June 12th 06 08:16 PM
Link 'failing'	ppetts	Links and Linking in Excel	1	October 5th 05 06:20 AM
Userform_Initialize event failing to be called	R Avery	Excel Programming	2	March 3rd 04 04:06 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us