Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fit text in cell of a protected worksheet
Good afternoon.
I have a form with protection and validation in several cells; some are left unlocked/no validation to allow for free form text entries. My problem is that when i protect the sheet, Excel doesn't auto fit the text in the column/row and the user is not able to either. (I don't want to allow Format row height / column width in Protection options, as I don't want any hidden rows/columns unhidden, which these protection options allow) Is there a way to allow the user to modify the row height and column with of the unlocked text cells (as needed) while the sheet remains protected? Or a way for Excel to do this automatically? I have wrap text selected in the cell format options. Thanks! -- Suzanne. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use auto filter in a protected worksheet | Excel Discussion (Misc queries) | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
Help with using Auto-filter in a protected Worksheet. | Excel Discussion (Misc queries) | |||
Auto Filter with Protected Worksheet | Excel Worksheet Functions | |||
HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . | Excel Worksheet Functions |