Posted to microsoft.public.excel.programming

Patrick Simonds Patrick Simonds is offline

external usenet poster

Posts: 258

Disabling Events

I use the following code to disable macros, but it is to indiscriminate.

Application.EnableEvents = True

Is there any way to disable only Private Sub Worksheet_SelectionChange
events and still allow other events to happen?

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
Prevent user disabling events	JP Farrow	Excel Programming	1	September 29th 04 04:49 PM
Disabling/enabling events with a button created by code??	Simon Lloyd[_518_]	Excel Programming	5	July 7th 04 12:09 PM
Disabling Alt+F11	richard_b2004	Excel Programming	3	May 17th 04 06:32 PM
Disabling Events	MWE[_28_]	Excel Programming	4	February 6th 04 05:39 AM
Auto_Open disabling	Tritan	Excel Programming	6	July 22nd 03 11:48 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us