Worksheet change event

[Mongy]

I have a basic worksheet change event, where on the one worksheet, cell changes values (case is), rows are hidden, or unhidden.

I'm not fluent/skilled enough, is there a way that when there is a change to a value in a cell in sheet1 (let's say "Show me" and "Where did it go"), that it triggers rows (10:15) to be hidden/unhiiden in sheet2?

 

[My Aswer Is This]

So try this if you will be entering Show me Or Where did it go in Range("A1") of Sheet(1)

If not modify code to your needs

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the Sheet(1) tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

[LEFT][COLOR=#222222][FONT=Tahoma]Private Sub Worksheet_Change(ByVal Target As Range)[/FONT][/COLOR]
[COLOR=#222222][FONT=Tahoma]'Modified  3/6/2019  9:53:03 AM  EST[/FONT][/COLOR]
[COLOR=#222222][FONT=Tahoma]If Target.Address = "$A$1" Then[/FONT][/COLOR]
[COLOR=#222222][FONT=Tahoma]    If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub[/FONT][/COLOR]
[COLOR=#222222][FONT=Tahoma]If Target.Value = "Show me" Then Sheets(2).Rows("10:15").Hidden = True[/FONT][/COLOR]
[COLOR=#222222][FONT=Tahoma]If Target.Value = "Where did it go" Then Sheets(2).Rows("10:15").Hidden = False[/FONT][/COLOR]
[COLOR=#222222][FONT=Tahoma]End If[/FONT][/COLOR]
[COLOR=#222222][FONT=Tahoma]End Sub[/FONT][/COLOR][/LEFT]

 

[Mongy]

Thank you. Enough information in there to get me thru

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thank you. Enough information in there to get me thru