|It's not clear to me what sheet tab you are clicking on but any Worksheet event code has to be placed in the sheet module for the sheet (and every sheet) where you want this to happen.|
Worksheet event macros are not global, they are Worksheet specific.
If you want the date to appear in Sheet1 Column R, then you need to right-click the Sheet1 tab and paste code into the pane that opens.
The only other reason that I can think for the code not to work for you (it works for me) is if you have some code that has turned events off.
If the line:
Application.EnableEvents = False
has been run in any macro while the current Excel session is open, then no event code will fire since the execution of that line impacts the application, i.e. Excel.
Quitting Excel and restarting it or running the following line will enable events again:
Application.EnableEvents = True
Note: if you have a Macro that runs the "False" line at Excel start-up, then even quitting and restarting Excel won't help since the code will disable events as soon as Excel starts.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.