Need help with Protection

  • Thread starter Thread starter Gerd
  • Start date Start date
G

Gerd

I have a spreadsheet in which I have a Command Button
which will clear the contents of a range of cells when
clicked. I have this worksheet protected except for the
cells which I am needing to be cleared by the Command
Button. It works fine when the worksheet is not
protected, but when I add the protection I get a dialog
box which says "Run-time error '1004' The cell or chart
you are trying to change is protected and therefore read-
only."

The funny thing is that on another worksheet in the same
workbook I have done exactly the same thing and it works
fine. I know absolutely nothing about programming so if
it is a complicated solution I would probably need step
by step instructions.

Any help on this would be greatly appreciated.
 
I have found my problem. I had changed the range of
cells and therefore some of the cells that I was trying
to clear were protected.
 
Back
Top