Hi folks, I'm hoping to beg for a little code to help with a project I'm trying to finish.
In B1 on a page called "Setup", I have some text that would normally be red in color. My goal is to have the text color change to the cell's fill color upon opening the workbook with macros enabled. If they are not enabled, the text would remain red, clearly noting that the workbook has not been opened properly with macros enabled.
Any ideas? Any better approaches? Thanks in advance for any help.
Oh - and how does one go about finding the correct color reference so that the right value can be identified and assigned to the changing text color?
Thanks! - Rich
In B1 on a page called "Setup", I have some text that would normally be red in color. My goal is to have the text color change to the cell's fill color upon opening the workbook with macros enabled. If they are not enabled, the text would remain red, clearly noting that the workbook has not been opened properly with macros enabled.
Any ideas? Any better approaches? Thanks in advance for any help.
Oh - and how does one go about finding the correct color reference so that the right value can be identified and assigned to the changing text color?
Thanks! - Rich