Excel 97- Protection of data

[shaygate]

STOP PRESS - After i wrote this I went back and had another play and found the 'lock' function for cells which when used alongside the worksheet protection does exactly what i wanted it too !
Ian

****************************************************

A long time ago when i first started using spreadsheets I used a simple package called SuperCalc 4, one of the functions it allowed me to do was 'protect' from change (editing) specific cells, rows and / or columns.

I can't seem to get Excel to do the same, it seems only able to provide crude protection to whole sheets or offer tracking of changes unless of course you know better !

(Just for interest, what I am doing is sending worksheets out to home based staff, on the sheet is information such as client names, tasks visit dates, reports to typing and so on. I want them to be able to input dates and comments but not change client names, tasks and so on. I used to print the sheets and fax them out but we are trying to move into the e mail age now !)

Any suggestions greatfuly received !

Ian

 

[itsmeitsmeitsme]

1. select the whole worksheet
2.choose format,cells to open format cells dialog box
3.click the protection tab and deselect the locked option,click ok
4.now select the range youwant to protect
5.choose format cells again and protection and check the locked box and then ok
6. choose tools,protection,protect sheet and then ok

Now when you go to the cells you will not be able to put info in the areas you previously selected.

hope this helps