Hello Twaddy,
This version of the macro works for me. Remove any Worksheet_Change() event code you have in the workbook. Follow the directions below to install the macro.
NOTE: When a formula calculates, it does not trigger the Worksheet_Change event.
How to Save a Worksheet Event Macro- Copy the macro using CTRL+C keys.
- Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
- Left Click on View Code in the pop up menu.
- Paste the macro code using CTRL+V
- Make any custom changes to the macro if needed at this time.
- Save the macro in your Workbook using CTRL+S
Bookmarks