Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it possible to lock a column width from other users but still allow them
to type in the cells? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "KD" wrote in message ... Is it possible to lock a column width from other users but still allow them to type in the cells? Sure. Format the cells so they're UNlocked. Then, protect the sheet (Tools, Protect, etc). If your main concern is klutzes who changes things accidentally and then say "Duhh.....nah....I didn't touch nuthin'...honest", you don't need to password protect the sheet - just use the protect thing, and don't enter a password. Users like that never find their way that deep into the menus. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column Width | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Column Width | Excel Discussion (Misc queries) |