I have a function that I have pasted into the "This Workbook" module in the VBA Project for my Excel 2010 workbook.
Public Function IsADate(cel) As Boolean
IsADate = IsDate(cel)
I was expecting that in a cell in the spreadsheet that I could now type =IsADate(C3). But when I do Excel does not recognise the function and I get a #NAME? error.
I'm sure this used to work on older versions of Excel (but could be wrong!)
I've Excel I've enabled all macros and ticked trusted access to the VBA Project object model...
What am I doing wrong? Thanks in advance.