Grayed out Auto-Sum on Protect Worksheet

T

Todd Walton

Why is it that when I protect a worksheet the Auto-Sum is greyed out,
even on cells that I should be able to edit?
 
P

Peo Sjoblom

Edit is not the same as using

=SUM(A1:A10)


Besides where does it say you can edit the cells, in my 2003 it says
edit objects and the default is that you can select unlocked cells.


Anyway if that is what you meant that you have certain cells unlocked and
the sheet protected

If you use the keyboard shortcut it works if you have unlocked cells (Alt
and =)


--


Regards,


Peo Sjoblom


--


Regards,


Peo Sjoblom
 

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 to unlock workbook? 1
AUTOFILTER IN A PROTECTED WORKSHEET 1
Form and protect sheet 2
Worksheet Protection not Working 6
Excel won't allow me to delete a worksheet. Why? 1
Protect Only Certain Cells 2
Password Protect Specific Range Of Cells 6
How do I protect a row with functions in it? 2

Top