Macro recording is missing steps

[Linda G]

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

 

[MARK858]

To run the code
If you are in the editor you can click anywhere in your code and press F5

If you are on the sheet you can press ALT + F8, click on your macro name (if there is only one macro then it will automatically select it) and click Run

or on the Developer tab click the Macros icon (you'll probably have to make your Developer tab visible as it is hidden by default), which will take you to the same dialog box

or assign the macro to a button or a shape