Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?

Hi!

I have seen similar posts for this however when I tried to employ the suggestions/code it wouldn't work for me.

I have an excel book that has a form that users need to fill out and then "sign" to say they have done what they were suppsed to do.

What I want to have happen is that when they select 3 different cells on this tab, different rows hide or unhide etc. Right now the only way I can get it to run is to do it through <<Private Sub Worksheet_Change(ByVal Target As Range)>>.

But this means that when other actions happen on this tab (i.e. other buttons/macros run, other cells have data entered into them) the this private sub macro is continually firing.

How can I make it fire ONLY when either or both of these 3 "target" cells are changed? These cells are E6 (named as "TypeofWork"), E7 (named "AddClientLine") and S43 (named "TotalTriggers").

Any help would be much appreciated!

Please Login or Register  to view this content.

You can't stop it from firing but you can make it switch right back:

Please Login or Register  to view this content.

You're welcome!