Can you protect a worksheet from having the columns resized,not ro

[Guest]

I want to protect the columns so the sheet can't be made wider, but not the
rows so they can be made higher.
Am I making sense?
Or is there a way to make the rows so they will automatically change to
accomodate word wrap that might go to three or even four lines so I can
protect the whole sheet?
Thanks, Meenie

 

[Guest]

Hi Meenie

It seems that there is...Select the cell or cells that you want to allow
your user to type into. Right click them and select "Format Cells" and then
go to the 'Protection' tab in the Format Cells dialog box.

On the protection tab, un-selelct "Locked" then go to the 'Alignment' tab
and select "Wrap Text" under 'Text Control'...about a third of the way down
in the dialog box, then OK.

Make sure the column is the correct width, then go to
Tools|Protection|Protect Sheet.

In the 'Protect Sheet' dialog box, you can select a number of options to
allow the user to do. What you check is allowed, so select Format Rows, but
do not select Format Columns.

You might also un-check "Select locked cells" which will focus the user
interaction into only the cells you want them to be in.

You will have an option to create a password, WRITE IT DOWN if you do so
because you will have trouble if you forget it. Then OK to protect the sheet.

I tested this and typed a sentence too long for the cell I prepared and the
row automatically resized itself but the column remained the same.

Hope this helps, if it does or if this needs further clarification, please
let us know. SongBear

 

[Guest]

Hmmmm problem. When I select "Tools" "Protection" "Worksheet" I get the
choice of choosing to protect: "contents", "objects",or "scenarios" (I can
check any or all, they default to all checked) I don't get all those other
choices. I have excel 2000 - maybe that's my problem?
Thanks! Meenie

 

[Guest]

Hi Meenie
That might be the problem, sorry that I don't have 2000 in order to check, I
have 2003 and it has 15 different choices of ways to protect the contents and
format of the worksheet.
I do remember the contents, objects, scenarios choices from before now, had
forgotten about them because I have used 2003 for two years.
Apparently the choices that are offered now under protection have replaced
those three choices as they are no longer in the protect dialog box.
You might still accomplish it with VBA code becaues you can unprotect and
re-protect a worksheet (including using a password) from code.
Are you interested in such a solution? It would require some colaborative
work between us since we would have to figure out how to trigger the code
(make it run) without slowing down the overall application.
SongBear