Mar 11 2020 09:33 AM
Mar 11 2020 09:59 AM
Did you save the file as Macro-Enabled Workbook?
Point to remember is, only .xls or .xlsb or .xlsm file can hold the macro in it.
Mar 11 2020 10:06 AM
Mar 11 2020 10:17 PM
Check the attached in which I have placed the code on Sheet1 Module, let me know if that works for you.
Make sure to enable the macros in the file when prompted. If macros are disabled, they won't work.
Mar 13 2020 07:53 AM
Mar 13 2020 10:49 AM
This is selection change event code which gets triggered automatically when you change the selection on the sheet and it should be placed on the Sheet Module but not on a standard module like Module1.
To place the code on to the Sheet Module, right click on the Sheet Tab Name and choose View Code and then paste the code into the opened code window, save your file as Macro-Enabled Workbook.
The file I uploaded with the code would work each time you open it because the code was placed on the Sheet Module.
Mar 13 2020 11:12 AM