Disabling Sheet Code

[Chip Pearson]

Stuart,

You can disable event processing with

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

 

[Stuart]

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.

 

[Stuart]

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

stuart