Quick Excel Question

Soldato
Joined
17 Nov 2004
Posts
10,199
Location
The Republic
Hola

Quick question regarding Excel. I have built a spreadsheet for one of my colleagues. Its a very basic calendar on one page. 12 months across from cells B-M and the days down the side. Screenshot can be seen Here

Basically there is a number in the relevant cell corresponding to the date in that month. Is it possible to protect that number in the cell(so it can't be deleted) but still be able to write to the cell. Unfortunately we are running on Windows 98 & office 97 so I can't download a compatible template from Microsoft and there is no wizard I can use in the version of office we have.

Its goign to be shared on a central drive for the purposes of reserving the cars we have for our team so they don't get double booked.

Cheers Loki
 
Thank you will search that

I suspect the answer to my question will be no. Prob due to the fact of were using an O/S and office no longer supported by Microsoft and no template kind of things being available.
 
I'm fairly (not 100%) sure that you can't do it. You can protect cells but not different data within a cell.

If I were you I would redesign the sheet so that you can protect the cells which contain the numbers.
 
Back
Top Bottom