Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Freezing cells...
Hi...I have a set of stock figures which decrease whenever a sale is made and
the data is entered in the right coloumn. I need to know how to make sure the clients who Im sending this spreadsheet out to do not input data in the stock column and messing up the spreadsheet. i.e. Stock Sales 4 0 3 1 3 1 2 2 So I need to make sure the stock coloumn is protected so the client cannot enter data into it. Hope this makes sense...Thanks in advance.. |
#2
|
|||
|
|||
Hi
- select the cells for which you want to allow entries - goto 'Format - Cells - Protection' and uncheck 'Locked' - now goto 'Tools - Protection' and protect your sheet Note: This protection mechnism is not very strong and an experienced Excel user can easily circumvent it -- Regards Frank Kabel Frankfurt, Germany "ANDREW_B" schrieb im Newsbeitrag ... Hi...I have a set of stock figures which decrease whenever a sale is made and the data is entered in the right coloumn. I need to know how to make sure the clients who Im sending this spreadsheet out to do not input data in the stock column and messing up the spreadsheet. i.e. Stock Sales 4 0 3 1 3 1 2 2 So I need to make sure the stock coloumn is protected so the client cannot enter data into it. Hope this makes sense...Thanks in advance.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |