Protection and commandButtons
Hi, To all Gurus!
When I protect a particular worksheet, it includes formulas on certain cells.
However, when I click a commandbutton the macros should run to change a particular cell to another value, even though a formula like "=Sum(K2+K3)" is laready on that cell.
This is not the case when Sheet Protection is on. Each time I click on the Commandbutton, it displays this "Sheet is protected".
How do I go about it to run the procedures attached to the commandbuttons in a protected sheet, as other cells are also required to be protected.
The answer given by Excel is to unprotect the worksheet, but this will lead to other cells that should be protected becoming unprotected again!