cell protection

  • Thread starter Thread starter Guest
  • Start date Start date
hi,

goto the cell, use Format/Cells/Protection ensure that
the cell has locked ticked.

Goto Tools/protection/protect sheet. supply a password if
you need to and if you have later versions of excel you
can specify some options.

You will also need to UNLOCK the cells you want the user
tobe able to use.

Steve
 
You must log in or register to reply here.

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

How do I protect cells or a range of cells in excel spreadsheet? 1
Protecting is NOT working right !!!!!!!!!!!!!! 6
hide columns on a protected sheet 2
Protect formulas which reference to unlocked cells in protected s. 5
what do { } mean/do? 3
Pasting formulas advances cell reference 2
I can still select & manipulate locked & protected cells in '07 1
Cell Protection 2

Back
Top