View Single Post
Old February 22nd, 2005, 04:05 AM
bahachin bahachin is offline
Authorized User
Join Date: Jan 2005
Location: Kuala Lumpur, Fed. Territory, Malaysia.
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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!