Sum Function and protected sheet
Posted by Judi on May 31, 2000 12:45 PM
In excel 97 the sum toolbar button is grayed out if the sheet is protected. Is there a way to use the sum function or a simple substitute on a protected sheet? I have 2 unlocked columns and the user keys data in to the first and I want them to select the cell in column 2 that is at the end of a group of data in column 1 and to click the sum button and highlight a range to total from the first column. It works if the sheet is unprotected. Thanks for the help.