Disabling protected cell selection
 

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!


--
sneakyzeal
------------------------------------------------------------------------
sneakyzeal's Profile: http://www.excelforum.com/member.php...o&userid=26978
View this thread: http://www.excelforum.com/showthread...hreadid=465478

After you 'lock' the cells, you need to Protect the worksheet. During
the Protection process, you can choose to not allow the user to select
Locked cells.

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=465478