Hi,

It has to be pasted into 'This Workbook' so as Dave says, right click the
sheet tab, view code, double click 'This workbook' and then paste it in on
the right.

Mike

"Dave" wrote:

Hi,
If Alt with F11 isn't working, right-click your sheet tab and choose View
Code.
The VBA window will open.
Paste Mike's code into the blank section on the right, then close the VBA
window.
Dave.