I cannot test your macro as I do not have the HebrewDate worksheet function.

Assuming you have that function, you may have put  the macro in the wrong
place. It must be in a module rather than in a worksheet or workbook object.
Only modules publish their functions so they can be used in the worksheet.