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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do i protect a worksheet in Excel and still use AutoSum? (https://www.excelbanter.com/excel-discussion-misc-queries/99600-how-do-i-protect-worksheet-excel-still-use-autosum.html)

Jonathan Newman

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

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.

SamuelT

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

Why not make a copy of the protected spreadsheet and unprotect it. That
way if any pesky little 'uns mess things up, it won't matter...

--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=561991

All times are GMT +1. The time now is 12:47 AM.