Two macro's assigned to one checkbox

Hello,

I recorded these 2 macro's:

Please Login or Register  to view this content.

I Need to assign these to macro's to one checkbox. Macro1 when checkbox is checked, and Macro2 when checkbox is unchecked.

Thanks!

Create your Tickbox on the sheet, link it to a cell (I've used A1 for this);

Assign this macro (by right clicking on it) to it;

Please Login or Register  to view this content.

You can of course change the A1 reference to whatever works for you

Does that work for you?

If it's an ActiveX CheckBox...


Enter Design Mode (Developer Tab > Controls > Design Mode)
Right click on the checkbox, select View Code


A click event similar to the following will be created:

Please Login or Register  to view this content.

Modify it to (as appropriate):

Please Login or Register  to view this content.

I'd suggest more meaningful names be used for the CheckBox & Macros.

Regards

Tooley

Tx! exactly what i was looking for

Your sollution works fine but if i protect the sheet is gives a 'run-time error "1004": application-defined or object-defined error.
Do you have any idea how i can solve that?