Partial sheet protection

[Guest]

How do I protect a sheet so that a user can still hide, un-hide, or add lines
????? Protecting cells, contents, and objects in the usual way does not
allow the user to do so.

If not, is there a way to DISABLE the user's ability to re-format cells,
columns, and lines while still letting them add lines?

I hope this makes sense. Help!

 

[Guest]

Tools > Protection > Protect Sheet

Play with some of the options. Unfortunately I can't seem to allow hiding
and unhiding rows. Record a macro while changing and mess with the
properties in VBA.

 

[Guest]

For the OP, JW is assuming you are using xl2002 or later.

 

[Guest]

Thanks Tom! Forgot about that!
--
JNW

For the OP, JW is assuming you are using xl2002 or later.