Macro to change tab color

[aguilar25]

Hello again,

Im trying to get the tabs color to change, I created some invoices and have a master sheet where all the invoices #, date, total amount and paid date and also a checkbox control so that when the invoice is paid i will just check mark the box, so I was wondering if there was a macro or formula or something that could automatically change the tab color once i check the box? everything is on A-d and the check box is on E what should i do?

[Richard Buttrey]

Hi,

Attach the following macro/code to your checkbox or preferably just a simple button.

Please Login or Register  to view this content.

[aguilar25]

Hi Richard, I tried that but it didnt work, am i doing something wrong?

[Richard Buttrey]

Hi,

Can't say without seeing what you've done. Upload your workbook so that we can take a look.

Regards

[aguilar25]

Hi Richard,
Here is an attachment maybe instead of having a checkbox i can just go off of the cell in the paid Ck#, I attatched an example maybe you can help me or anyone else, I would really appreciate it, thank you

Claudia