Hiding a row across multiple sheets

[frankday]

I am trying to hide row 129 across these sheets. It works great but when done all the sheets are high lighted. I want it to return to sheet "Chart of Accounts" only. It doesn't mater what cell. Any help would be great. Thanks

Sub Line129callapes()


Sheets(Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December")).Select
Rows(129).EntireRow.Hidden = True
Range("A144") = 0
Range("B144").Select

End Sub

 

[frankday]

Is there a way to download my sample file? Or can I send you a sample file?

 

[My Aswer Is This]

I never open other people's files.

You asked for a script and I provided what you asked for.
You then modified my script to another row. But now because you have other scripts that hide and unhide other rows the two scripts are working against each other I guess.

Looking at you file would not help me.

I know on this forum there are lots of people wanting to hide and unhide rows.

This can become very confusing to me at least. Hide this row if that happens and unhide this row if this happens.

So I normally leave those type questions to others here on the forum to answer.

Your original question seemed very simple so I answered it for you.

But now it seems there are more of these hide and unhide scripts in your sheet.

So I would prefer to let others here on the forum answer this new question of yours.
I will continue to monitor this thread to see how things work out for you.
Sorry but this is now beyond my knowledgebase.

 

[frankday]

I understand. Thanks for the help.

 

[sheetspread]

when I hide a row using the "my sheets" code that was posted yesterday by board regular and then I use the code that hides multiple sheets, when I unhide using the multiple sheets code it also unhides the row that was hidden by "my sheets" code.

Which rows do you want to remain hidden?

 

[frankday]

I want to keep row 7 hidden on every sheet even when I run the second Code. Then I can run the first code with ".Rows(7).Hidden = False" to unhide row 7

I have a hidden row inside hidden rows.

 

[sheetspread]

Add an if statement (quick fix)

 

[frankday]

I'm sorry. If statement where