How do i protect a worksheet in Excel and still use AutoSum?

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

Guest

If I protect a worksheet in Excel 2003, the AutoSum button cannot be used. As
I want to use the protected sheet with students in school, I would like them
to be able to use the AutoSum button.
 
Why not make a copy of the protected spreadsheet and unprotect it. Tha
way if any pesky little 'uns mess things up, it won't matter..
 
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

autosum 1
Autosum doesn't work. How do I get column total? 2
Autosum not displaying until spreadsheet saved 1
HOW TO TURN ON 'AUTOSUM' ON ON A PROTECTED SHEET THRO VB 6
autosum 3
Add Average Function to a toolbar with an exclusive icon? 3
An odd problem with SUM(A:B) and AutoSum 2
Autosum doesn't recognize cell values after I cut and paste valuesfrom web page 5

Back
Top