Disabling protected cell selection

  • Thread starter Thread starter sneakyzeal
  • Start date Start date
S

sneakyzeal

I've had a search around on the forums for posts to help me but can't
find anything!

I'm using Excel 2000 and I want to know.. is it possible to not allow
protected/locked cells to be selected with the mouse or arrow keys? I
think you can with Excel 2003.

On that note.. if a spreadsheet is created in 2000 and viewed by
someone in a later version, will it be completely compatible? Or vice
versa; if I was able to use the function I mentioned above in a 2003
version then viewed in 2000, would it work the same?

Thanks in advance!
 
After you 'lock' the cells, you need to Protect the worksheet. Durin
the Protection process, you can choose to not allow the user to selec
Locked cells.

HT
 
You must log in or register to reply here.

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

Similar Threads

Twin cells 5
Excel Protection 2
I can still select & manipulate locked & protected cells in '07 1
Change cell color in protected sheet 1
allow a user to edit ranges in a protected worksheet 3
Cell protection short cut button 1
Convert Decimal fractions to binary and vice versa 1
Excel 2000 help please - Cell protection 2

Back
Top