Hello there,
Attached is your sample worksheet update to include a code that runs when the workbook is open.
Be sure to enable macros when opening the workbook for it to work properly.
To incorporate this code into your workbook:
1. Press Alt+F11 on your keyboard.
2. This will bring up the visual basic window
3. On the left hand side you should see a ThisWorkbook option.
4. If you don't pres Ctrl+R to bring up the Project Explorer
5. Right click on ThisWorkbook and then select view code
6. Copy and paste the below code in the blank space provided.
7. Close out of Visual Basic and then you should be good to go.
Let me know if this works for you.
Thanks!
Bookmarks