Partial sheet protection
 

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!

Partial sheet protection
 

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.
--
JNW


"brains" wrote:

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!

Partial sheet protection
 

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

--
Regards,
Tom Ogilvy


"JNW" wrote:

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.
--
JNW


"brains" wrote:

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!

Partial sheet protection
 

Thanks Tom! Forgot about that!
--
JNW


"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"JNW" wrote:

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.
--
JNW


"brains" wrote:

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!