Good afternoon!
Before I start, full disclosure, I am a total VBA/macro noob!
I have a spreadsheet containing several sheets. I cobbled together a VBA code I found on the internet, which is posted in the tab code, to change the tab colour depending on a value in a cell D1 of each sheet. The tab colours currently get updated by right clicking on the first tab name, view code, and then selecting "Run" and "Run sub/user form" from the menu in that window.
The spreadsheet is not going to be used by myself, so I want to make it as automatic as possible. I tried to make a macro to record all the updating steps, but I have found that nothing registers as soon as I right click the tab name..
Could someone kindly let me know what I have done wrong, or what I need to do to automate the process?
Very many thanks
Before I start, full disclosure, I am a total VBA/macro noob!
I have a spreadsheet containing several sheets. I cobbled together a VBA code I found on the internet, which is posted in the tab code, to change the tab colour depending on a value in a cell D1 of each sheet. The tab colours currently get updated by right clicking on the first tab name, view code, and then selecting "Run" and "Run sub/user form" from the menu in that window.
The spreadsheet is not going to be used by myself, so I want to make it as automatic as possible. I tried to make a macro to record all the updating steps, but I have found that nothing registers as soon as I right click the tab name..
Could someone kindly let me know what I have done wrong, or what I need to do to automate the process?
Very many thanks