check box problem

bakerman

Board Regular
Joined
Sep 9, 2005
Messages
188
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 ?
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

tsgdes

New Member
Joined
Aug 8, 2006
Messages
31
The macro you are running maybe trying to change a protected cell, hence causing the error
 

bakerman

Board Regular
Joined
Sep 9, 2005
Messages
188
Thanx, you were right, I forgot to unlock the cells that I have linked to the check box's
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,032
Messages
5,526,353
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top