Calendar Macro

Hi again,

You entered the code in a standard VBA module - you must enter it in the VBA module for the WORKSHEET. Right-click on the worksheet tab & select "View Code" - this will display the VBA module for the worksheet.

To extend the "activation range" use:

Const strCalendarCell   As String = "A5:B5"

Regards,

Greg M