Can't protect some cells in Excel 2003

G

Guest

I locked all cells in an Excel spreadsheet then protected the sheet. Some of
the sheet is set up as a form for users to fill in details and these cells
still allow editing which is fine. The problem is that one section of
formulas also allows editing. Does anyone know what else could be allowing
them to be edited?
 
G

Guest

Solved it. Someone had added the cells using the Allow users to edit ranges
option. I just had to remove all references to the cells in question.
 

Ask a Question

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.

Ask a Question

Top