Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you protect a worksheet from having the columns resized,not ro
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you protect a worksheet from having the columns resized,not ro
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 "Meenie" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you protect a worksheet from having the columns resized,no
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 "SongBear" wrote: 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 "Meenie" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you protect a worksheet from having the columns resized,no
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 "Meenie" wrote: 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 "SongBear" wrote: 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 "Meenie" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to protect cells from getting deleted or resized? | Excel Worksheet Functions | |||
rows and columns won't stay resized | Excel Worksheet Functions | |||
columns and rows on my worksheet will not stay resized | Excel Worksheet Functions | |||
Charts should not be resized when deleting rows/columns. | Charts and Charting in Excel | |||
Protect Objects so they cannot be resized | Charts and Charting in Excel |