#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 116
Default Locking columns

I want to lock columns so others can't get into the document and delete or
hide a column, however I want them to be able to add a row so they can fill
out the appropriate data in each column. How do I do this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Locking columns

Protect your workSHEET with a password. When you select to protect it, a box
will appear asking what you want users to be able to do or not to do. Delete
columns and insert columns can be enabled/disabled seperately here.

"Sherry" wrote:

I want to lock columns so others can't get into the document and delete or
hide a column, however I want them to be able to add a row so they can fill
out the appropriate data in each column. How do I do this?

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
Greying out or locking certain columns Jen Excel Discussion (Misc queries) 0 February 22nd 08 06:02 PM
Locking all cells accross when sorting columns David New Users to Excel 2 September 9th 06 09:26 PM
Locking columns and not protecting whole sheet changetires Excel Discussion (Misc queries) 3 July 13th 06 05:46 PM
Locking columns chefatl Excel Discussion (Misc queries) 1 March 16th 06 12:20 AM
Locking and Hiding Columns JerryS Excel Discussion (Misc queries) 3 December 17th 05 04:24 PM


All times are GMT +1. The time now is 02:26 AM.

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

About Us

"It's about Microsoft Excel"