View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Disabling worksheet_change when deleting rows . .

Maybe if
Target.Columns.count = 256
you could ignore the event. Not sure what your code is meant to catch, so
that may or may not work in your case.

Tim.

"Adam" wrote in message
oups.com...
Ok, Here's another one . .

I am using Application.CutCopyMode = 0 and it properly disables the
events inside worksheet_change()

However, when I delete rows with the menu delete, it is triggering
events in the worksheet_change() function in the sheet.

How do I disable worksheet_change() when we delete rows?

Thanks!
Adam