Protecting a Worksheet

J

Jeff

Does anybody know how to protect a workbook so that a user
CANNOT unhide a sheet, CANNOT add rows to the viewable
sheet, CANNOT alter locked cells, but CAN add text to a
comments column which will expand and Wrap text as the
comments increase in size?

I understand how to protect/unprotect locked cells, but I
cannot find the right combination for the above
functionality. Is it even possible?

Any help is greatly appreciated.

Jeff
 
J

Jim Rech

When a _Workbook_ is protected (Tools, Protection, Protect Workbook,
Structure) sheets cannot be unhidden.

When a _Worksheet_ is protected locked cells cannot be edited and rows
cannot be inserted. However, unlocked cells with Wrap Text set will still
accept entries and will word wrap and autosize row heights. This isn't true
for merged cells but then merged cells never do an autofit.

--
Jim Rech
Excel MVP

| Does anybody know how to protect a workbook so that a user
| CANNOT unhide a sheet, CANNOT add rows to the viewable
| sheet, CANNOT alter locked cells, but CAN add text to a
| comments column which will expand and Wrap text as the
| comments increase in size?
|
| I understand how to protect/unprotect locked cells, but I
| cannot find the right combination for the above
| functionality. Is it even possible?
|
| Any help is greatly appreciated.
|
| Jeff
|
 
Top