Partial sheet protection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brains - 13 Sep 2007 20:12 GMT

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!

Reply to this Message

JNW - 13 Sep 2007 20:22 GMT

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.

Signature

JNW

> 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
[quoted text clipped - 4 lines]
>
> I hope this makes sense. Help!

Reply to this Message

Tom Ogilvy - 13 Sep 2007 20:28 GMT

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

Signature

Regards,
Tom Ogilvy

> Tools > Protection > Protect Sheet
>
[quoted text clipped - 10 lines]
> >
> > I hope this makes sense. Help!

Reply to this Message

JNW - 13 Sep 2007 20:32 GMT

Thanks Tom! Forgot about that!

Signature

JNW

> For the OP, JW is assuming you are using xl2002 or later.
>
[quoted text clipped - 12 lines]
> > >
> > > I hope this makes sense. Help!

Reply to this Message