disable Private Sub Worksheet_Change(ByVal Target As Range)

**maacmaac** · 01-06-2011, 03:55 PM

I have a macro that is creating formulas in a spreadsheet. The only issue I have (and I think it is slowing down the code) is that everytime I create a formula in each cell the code calls the "Private Sub Worksheet_Change(ByVal Target As Range)" code each time. Is there a way to disable temporarily and then enable once the macro is complete? Thanks.

**StephenR** · 01-06-2011, 03:58 PM

Do you really need to apply change event to every cell?

If so, add

Please Login or Register  to view this content.

at the start, and turn back on at the end.

**shg** · 01-06-2011, 03:58 PM

Please Login or Register  to view this content.

**maacmaac** · 01-06-2011, 04:42 PM

Thanks for comment. I only need the change event for one single cell. Do I have the code written correctly?

Please Login or Register  to view this content.

**shg** · 01-06-2011, 05:05 PM

Try this:

Please Login or Register  to view this content.

**maacmaac** · 01-06-2011, 05:39 PM

That works fine. Thanks

disable Private Sub Worksheet_Change(ByVal Target As Range)

LinkBack

Thread Tools

Rate This Thread

Display

disable Private Sub Worksheet_Change(ByVal Target As Range)

Re: disable Private Sub Worksheet_Change(ByVal Target As Range)

Re: disable Private Sub Worksheet_Change(ByVal Target As Range)

Re: disable Private Sub Worksheet_Change(ByVal Target As Range)

Re: disable Private Sub Worksheet_Change(ByVal Target As Range)

Re: disable Private Sub Worksheet_Change(ByVal Target As Range)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions