By default, ALL cells are locked on a new worksheet. However, the locking
doesn't take effect until you protect the worksheet (tools/protect...)
What you need to do is select all the cells which CAN be changed by the
user, and UNProtect them, then protect the worksheet.
HTH
Bob Umlas
Excel MVP
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
