Freezing cells...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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..
 
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
 

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

Access Stock In Hand query in access 2007 0
Autofill upwards!!!!! 4
Multiple Worksheets 1
moving data to one row 4
Excel Formula to add stock 7
Finding Last Entry in a Column 1
Consolidated array 3
ind the max among data 2

Back
Top