| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grayed out Auto-Sum on Protect Worksheet
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Grayed out Auto-Sum on Protect Worksheet
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 "Todd Walton" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn on Auto Filter?? It is grayed out. | Excel Discussion (Misc queries) | |||
| Auto Filter is unavailable - grayed out | Excel Worksheet Functions | |||
| New record button grayed out on auto form w/ shared workbook | Excel Discussion (Misc queries) | |||
| Auto Filter Option grayed out | Excel Discussion (Misc queries) | |||
| How do I auto-protect a worksheet? | Excel Worksheet Functions | |||
Linear Mode
