Thread
:
Disabling Sheet Code
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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.
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson