Posted to microsoft.public.excel.programming

Trevor Williams Trevor Williams is offline

external usenet poster

Posts: 181

XL2002 - trigger sheet event BEFORE deactivating

Hi All

I want to inform a user of incomplete cells if they attempt to move to a
different worksheet.

The Worksheet_Deactivate event takes the focus away from the current sheet
before running the code. Is there another event I can use that runs before
displaying the next sheet?

Thanks in advance

Trevor Williams

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
Event Trigger	lobo	Excel Programming	5	December 16th 05 08:33 PM
Deactivating Multipage Change Event	[email protected]	Excel Programming	0	September 9th 04 03:13 AM
Deactivating Multipage Change Event	[email protected]	Excel Programming	2	September 9th 04 02:49 AM
Trigger Event	Todd Huttenstine	Excel Programming	2	July 14th 04 06:50 PM
Format Event Trigger (XL2002)	Ronald Dodge	Excel Programming	2	April 27th 04 09:48 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us