Protect cells

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

Guest

Hello

Before upgrading my Microsoft office, i can use the function protect cell
which protect specified cells (i.e. A15 or B24) or a particular column. Now
after upgrading Microsoft Office 2003, i cannot protect protect any specified
cells in my worksheet instead the entire sheet will be protected. Please
help me to solve my problem.

Thank you. More power!
Tata
 
Hi
you first have to format the cells which should not be protected
('Format - Cells - Protection' and uncheck 'Locked')
 
In addition.........before upgrading you also had to protect the worksheet
before the cell protection comes into effect.

No difference in newer versions.

Gord Dibben Excel MVP
 
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

Protected cells can't be grouped 1
Change cell color in protected sheet 1
Deleting Rows Containing Protected Cells 2
Grouping on protected worksheets 4
Protecting Cells In A Worksheet 1
protecting certain cells in Ecxel 2007 2
Protection of certain cells or columns 2
limited cell movement 2

Back
Top