Disabling Sheet Code
 

Stuart,

You can disable event processing with

Application.EnableEvents = False
' your code here
Application.EnableEvents = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Stuart" wrote in message
...
How do I disable Sheet code such as "Private Sub
Worksheet_SelectionChange(ByVal Target As Excel.Range)" from working when
another sub in another module is operating on the sheet.

Disabling Sheet Code
 

How do I disable Sheet code such as "Private Sub
Worksheet_SelectionChange(ByVal Target As Excel.Range)" from working when
another sub in another module is operating on the sheet.

Disabling Sheet Code
 

Many thanks for the quick reply...........It works perfectly

stuart


Chip Pearson wrote in message
...
Stuart,

You can disable event processing with

Application.EnableEvents = False
' your code here
Application.EnableEvents = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Stuart" wrote in message
...
How do I disable Sheet code such as "Private Sub
Worksheet_SelectionChange(ByVal Target As Excel.Range)" from working
when
another sub in another module is operating on the sheet.