If I hide rows using TEXT, then All other rows will hide having the same text.

[rajeshn_in]

In below VBA code:
I want one small extension,
Because, If I unhide previous hided rows, then I can hide only 1 row with this formula, all other previous rows are automatically not hiding because of sheet is in protect mode. So, that.

If I select "HIDE ROW" in Column 5 cell, then HIDE that ROW and all other rows will HIDE having the same text in Column 5 and finally PROTECT sheet

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[rajeshn_in]

Try:

Please Login or Register  to view this content.

Thank you very much MUMPS1

[Mumps1]

My pleasure.