I don't think my question was clear. I understand how to lock or unlock cells. The problem I'm having isn't with this. What I'm seeing is that when the Worksheet Protection is on, and a cell is Locked, that users are able to enter data into the cell anyway.
Has anyone seen this before or have any idea why this would be happening. There is no VBA in this workbook, so there's nothing behind the scenes happening to turn off sheet protection. On Mar 17, 12:57 am, Dave Bonallack <davebonall...@hotmail.com> wrote: > Hi, > > Each cell has to be locked for protection to have any effect. > > Select one of the cells that is disobediently accepting data > > Format, Cells, Protection tab, click 'Locked' > > Do this for each cell you want to lock, or you can select lots of cells in > the ordinary way, or with the Ctrl key, and just do the 'Locked' thing once. > > Regards - Dave. > > > > > Date: Tue, 16 Mar 2010 10:35:15 -0700 > > Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking > > behavior > > From: jeffhollifield1...@gmail.com > > To: excel-macros@googlegroups.com > > > Hi all, > > > I've got an Excel spreadsheet that is used for collecting some data > > from end users and each tab uses Sheet Protection with a password, > > with users able to select locked & unlocked cells. We also have a mix > > of locked & unlocked cells on each tab. There's also no VBA in this > > workbook. > > > On one tab, there are several locked cells which can take data entry. > > Does anyone have any idea why this would be the case? I always > > thought that if Sheet Protection was on, Excel prevented any entry > > into a locked cell. > > > -- > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links > > :http://twitter.com/exceldailytip > > 2. Join our Facebook Group > > @http://www.facebook.com/group.php?gid=287779555678 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 6,800 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know > > they can subscribe to group > > athttp://groups.google.com/group/excel-macros/subscribe > > _________________________________________________________________ > Link all your email accounts and social updates with Hotmail. Find out > now.http://windowslive.ninemsn.com.au/oneinbox?ocid=T162MSN05A0710G -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
