Changes other sheets without jumping back and forth

[Loin75]

I have set a rule that if a cell on sheet A gets changed, then rows on sheet B become hidden.

Is there a way to make this happen without having to select sheet B in the process - as the user ends up watching the macro jump to sheet B and back again.

I'd like it to happen discreetly / silently..

Many Thanks

 

[JamesW]

Hi there,

Can you post your macro below? It's probably a simple 1 liner to add (Application.Screenupdating = False).

 

[Loin75]

Never posted in tags before. Can you explain how please..

(sorry for ignorance)

 

[Richard Schollar]

Hi

It would be easier if you had posted your existing code, but you don't need to Select a sheet to work with it - so in your Change event on the first sheet you can hide rows on the second without selecting it:

'for Sheet 1:
 
Private Sub Worksheet_Change(ByVal Target As Range)
 
If Target.Address = "$A$1" Then
  Sheets("Sheet2").Range("A3:A4").EntireRow.Hidden = True
End If
End Sub

 

[Loin75]

Utter genius... ---> (easily impressed)

Thanks Richard.

Would still like to know how to post code in tags. Is it this icon "wrap (quote)"??

 

[Richard Schollar]

Yeah just wrap the code in tags like this [ code ] Your code here [ / code ]

Omit the spaces and the board will fit the code into the code box

 

[Loin75]

 Thanks again...