Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I fix the column width?
I have an excel sheet wherein I collect data from about 10 persons.
To maintain formattin all over the huge excel sheet, I would like to freeze the column width. Other should not be able to change the column width even if they try. What should I do? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I fix the column width?
You can protect the worksheet (tools|protection|protect sheet).
But there are lots of things that can't be done on a protected worksheet. You'll want to test it first. Kazuki wrote: I have an excel sheet wherein I collect data from about 10 persons. To maintain formattin all over the huge excel sheet, I would like to freeze the column width. Other should not be able to change the column width even if they try. What should I do? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I fix the column width?
Highlight the columns and click:
Tools-Protection-Protect worksheet. Use p/w if you like. Corey.... "Kazuki" wrote in message ... I have an excel sheet wherein I collect data from about 10 persons. To maintain formattin all over the huge excel sheet, I would like to freeze the column width. Other should not be able to change the column width even if they try. What should I do? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I fix the column width?
"Kazuki" wrote in message
... I have an excel sheet wherein I collect data from about 10 persons. To maintain formattin all over the huge excel sheet, I would like to freeze the column width. Other should not be able to change the column width even if they try. What should I do? Tools/ Protection/ Protect worksheet Select options appropriately -- David Biddulph |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I fix the column width?
one way would be to put the if statement below into some worksheet event
such as calculate or change. Then when the column width is modified it will revert to 20. If you want it to fire all the time just use Columns(4).ColumnWidth = 20 ========== To add right click sheet tabview codeleft window worksheetright window select eventput in code Private Sub Worksheet_Calculate() If Columns(4).ColumnWidth < 20 Then Columns(4).ColumnWidth = 20 End Sub Private Sub Worksheet_Change(ByVal Target As Range) If Columns(4).ColumnWidth < 20 Then Columns(4).ColumnWidth = 20 End Sub -- Don Guillett SalesAid Software "Kazuki" wrote in message ... I have an excel sheet wherein I collect data from about 10 persons. To maintain formattin all over the huge excel sheet, I would like to freeze the column width. Other should not be able to change the column width even if they try. What should I do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Width | Excel Discussion (Misc queries) | |||
Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Is it possible to create one column with two different width? | Excel Worksheet Functions | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |