active sheet name from value and "autohide" code do not work together

[Sinsless]

Hello,
i have quite a problem. I use #codeA to change sheet name with value in specified cell (to has automatic changing value in header of each page). it works.
i added some code to autohide specific rows (lets say rows 11-15 in SHEET A) by specified cell value in other sheet DATA ("yes or no"). it works.
i put both codes together, nothing works. is it because of changing name of sheet A, and then "autohide" code doesnt catch correct sheet? please help if anyone can, i quite new to vba and dont know hot to solve this... dont have any code for the moment for autohide code


#CODE for changing sheet name (found in vba forums; working)

Private Sub Worksheet_Change(ByVal Target As Range)
Set Target = Range("G5")
If Target = "" Then Exit Sub
Application.ActiveSheet.Name = VBA.Left(Target, 31)
Exit Sub
End Sub

[Arkadi]

It would be better to provide the full code that is having problems so we can see what is wrong. I would be surprised if the sheet name changing has anything to do with "not working". Unless you have coded the name into the VBA

[Sinsless]

i was trying that for autohide, this version a bit a mess after i tried to work them both at the same time:

testA

Please Login or Register  to view this content.

testB (here "pav" was stated for naming the name changing sheet)

Please Login or Register  to view this content.

[Arkadi]

Test A and Test B are not for the same ranges, and also, one is a change event, the other a calculate event.
Maybe it is best to explain what you wanted to achieve with both the hide and the rename criteria. I assume they are to apply to the same sheet?

Is "Data Input" the sheet that has the code in it?