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