Disabling hiding rows

R

rudy

I am trying to protect my worksheet and not allow users to hide rows.
Under Tools -> Protection.... you can disable deleting rows but I
can't seem to protect users from hiding rows. When they hide rows and
execute some macros I have set up it is causing issues.

Thanks!
 
T

Tim Otero

Why not just add a line of code to your macro to unhide all rows? That
way no matter what the user does your macro still works.
 
R

rudy

This is what we may do. The issue is the users want save what they hav
hidden. Unhiding all rows and then restoring back I do not know how t
do.

Thanks
 
Top