check box problem

[bakerman]

I have a collection of six check box's on a spreadsheet. Each runs a different macro when selected and everything works fine. My problem starts when I protect the worksheet. I have unlocked each check box and also the cells which the check box's are in front of but I stil get the cell your trying to change is protected warning. Anyone got any ideas how to overcome this problem ?

 

[tsgdes]

The macro you are running maybe trying to change a protected cell, hence causing the error

 

[bakerman]

Thanx, you were right, I forgot to unlock the cells that I have linked to the check box's

 

[Jonmo1]

Try adding an Unprotect Statement to the beginning of each macro, and a protect statement at the end of each macro.

Unprotect the sheet at the beginnig of each macro with this :

ActiveSheet.Unprotect

Protect the sheet at the end of each macro with this :

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveSheet.EnableSelection = xlNoSelection

You may have to modify the protection code to suit your nees, that code will have ALL options Unchecked in the protection options.