Issue a warning if rows are unhidden (Prank)

[struf]

Is it possible to put a "warning" comment on some hidden rows so if they are unhidden, it pops up states that they should remain hidden. Its more of a friendly joke to a colleague who has this thing about hidden columns. If I broke etiquette by placing this in the questions instead of forum, i apologize.
Any suggestions are appreciated.

later

struf

 

[Jonmo1]

Re: Issue a warning if rows are unhidden

If you had not actually stated that it was intended as a joke, then this would be the right place...

Anyway I don't see any harm. A mod might move it to the lounge though..


You could do some code like

For i = 2 to 10 'From row 2 to row 10
If rows(i).Hidden = False Then
Msgbox "Dude, these rows are supposed to be hidden"
Exit For
End If
Next i

 

[struf]

Re: Issue a warning if rows are unhidden

many thanks. I will use the lounge movign forward on requests like this.

 

[litrelord]

Re: Issue a warning if rows are unhidden

Are there any worksheet events that capture the unhiding of rows? At the point you click unhide you won't change the sheet or selection, the sheet doesn't recalculate. I'm probably being a bit slow but I'm not convinced that this would work.

Would be interested to hear otherwise.

Nick

 

[RoryA]

Re: Issue a warning if rows are unhidden

if you have a subtotal formula somewhere referring to the hidden rows then a calculate event will be triggered.