ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   lock column width (https://www.excelbanter.com/excel-discussion-misc-queries/73498-lock-column-width.html)

KD

lock column width
 
Is it possible to lock a column width from other users but still allow them
to type in the cells?

Doug Kanter

lock column width
 

"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.




All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com