Excel - prevent someone from clicking into certain cells

S

Silverstreak

I received a spreadsheet in which you can only click into certain cells and
enter data. But I can't even click into the rest of the cells containing
formulas etc at all.

It isn't like protection, where you can click into the locked cells, but
when you try to enter data a message appears indicating that the cell is
locked. In the spreadsheet I received you simply cannot even click in the
cells.

What is this feature, and how do I turn it on? (it is functioning in both
Excel 2003 and 2007).

Any advice you can provide would be greatly appreciated....Thanks
 
B

Bernard Liengme

It is Worksheet Protection
As an experiment:
Open a new worksheet
Whichever Excel version (2003/2007) you have; start the process of
worksheet protection
You should see a dialog in which you can specify is uses can move to
locked, to unlocked cell, to other object

best wishes
 

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