Editing a protected Sheet
Posted by Charles Taylor on July 05, 2001 9:47 AM
Mr. Excel,
My professor has offered bonus points to anyone that can easily change the data in a cell of a password protected sheet. NOTHING but the sheet itself is protected. The data in the cell is just a number (50 in his example.) There are no variables, formulas, etc. I tried doing it with VBA but failed. He said I was trying to make it "too complicated". Any ideas? I could REALLY use that extra credit...
Thanks in advance!
Charles
Posted by Ben O. on July 05, 2001 10:06 AM
Is the cell that you have to modify locked? The sheet could be protected, but if the cell in question isn't locked, you should be able to change it.
Ben
Posted by Scott on July 05, 2001 11:08 AM
Interesting problem. Is it possible that the cell with the number 50 in it is actually a formula and the cell is formatted as "hidden", so you would not see the formula in the formula bar? If so, then the cells that make up the formula may be unlocked, but the cell with the 50 is locked, hence, if you change part of the formula, the 50 will change.
That's all I can think of. If it's something different, please post it. You've got me curuous.
S.
Posted by Tom Morales on July 05, 2001 11:30 AM
You could finesse the issue by copying the whole sheet, formatting and all, into a new workbook. The new sheet would be unprotected, and you could have your way with it.
Tom
Posted by cindy on July 10, 2001 8:22 AM
you can unprotect the sheet.. since you cannot edit and unlocked the cells if the worksheet is protected.. use this it may work
activesheet.unprotect
worksheets (name of worksheet).range ("a1") = 25
hope this will work..
follow up guys, how can i edit a protected sheet so that the it can accept new criterias for the solver.. the unprotect sheet is not working
