| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
| Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
| Partial cell protection? | Excel Discussion (Misc queries) | |||
| Gridlines on partial sections of sheet | Excel Discussion (Misc queries) | |||
| How Do You Turn A Partial Row Of Sheet Cells A Color From A UserForm | Excel Programming | |||
Linear Mode
