#1   Report Post  
Old February 23rd 06, 06:07 PM posted to microsoft.public.excel.misc
KD
 
Posts: n/a
Default lock column width

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

  #2   Report Post  
Old February 23rd 06, 06:20 PM posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Width zhj23 Excel Discussion (Misc queries) 0 February 12th 06 02:57 AM
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM
Changed column width keeps reverting back to original size David Boone Excel Discussion (Misc queries) 3 May 29th 05 01:22 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM
Column Width Deborah M Excel Discussion (Misc queries) 1 December 6th 04 04:27 PM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017