PC Review


Reply
Thread Tools Rate Thread

?How to add to a list when sheet is protected?

 
 
bentod
Guest
Posts: n/a
 
      15th Jan 2008
I have created a list using the pull-down Data->List->Create List.

I want to protect the sheet, but not entirely. I want to prevent
people from adding/deleting columns, selecting locked cells, and a few
other things.

First I use the pull-down Tools->Allow Users to Edit Ranges and select
the columns $A through $J (which fully contains my list).

When I select the Protect Sheet button and select the various check
boxes, everything works fine; however, I am unable to add to the
list. That is, if I go to the last row in the list, I can put in data
into the cells, but the list isn't updated. Therefore the autofilter
doesn't recognize the new row's data.

Is there something I can do?

Todd
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel List on Protected Sheet Lori H. Microsoft Excel Misc 0 31st Mar 2009 05:22 PM
Copying a protected sheet to another sheet or workbook loses prote Rudy Microsoft Excel Crashes 0 30th Nov 2007 10:17 PM
Protected sheet accepting values from List anandmr65 Microsoft Excel Misc 3 15th Feb 2006 02:43 PM
List, Data Validation, unlocked cell, protected sheet..... =?Utf-8?B?S2FuZQ==?= Microsoft Excel New Users 5 8th Jan 2005 10:39 PM
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet arunjoshi Microsoft Excel Programming 1 2nd May 2004 03:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:55 PM.