Checkboxes disable rows

If you use hundreds of check boxes your file size will be very big. I was suggested by Palmetto to use marlett checkboxes, which are very good alternative....
Link 1 http://www.vbaexpress.com/kb/getarticle.php?kb_id=879
Link 2 http://www.ozgrid.com/forum/showthread.php?t=35211

HTH

draozoth;

Here are 5 subs that can help you.

If you already have the checkboxes created, you can just assign macro "CheckBox_Click" to them.
CheckBox_Click will determine which checkbox was clicked and lock/unlock the row that it is on.

If you already have a macro that determines the checkbox that was clicked, just pass the checkbox object to "Lock_Row".

Create_All_CheckBoxes will create checkboxes with the default OnAction (CheckBox_Click). You just need to pass it the row # of the last checkbox. It assumes that there are no checkboxes on the activesheet.

Workbook_Open shows you how to call Create_All_CheckBoxes so it runs when the workbook is opened.

Create_CheckBoxes() will ask you for the bottom row if you need it, and call Create_All_CheckBoxes()

If you want to see how it works. Create a blank workbook, put all the subs (except Workbook_Open) in a standard module and then run "Create_CheckBoxes", then check & uncheck the checkboxes.

Please Login or Register  to view this content.