software

I am trying to protect my worksheet and not allow users to hide rows.
Under Tools -gt; 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!--
rudy
------------------------------------------------------------------------
rudy's Profile: www.excelforum.com/member.php...oamp;userid=33911
View this thread: www.excelforum.com/showthread...hreadid=542873Why 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.

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


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

Thanks.--
rudy
------------------------------------------------------------------------
rudy's Profile: www.excelforum.com/member.php...oamp;userid=33911
View this thread: www.excelforum.com/showthread...hreadid=542873