VBA now not recognising Functions such as Right(

[RobinClay]

Why, oh, Why, does VBA now not recognise Functions such as Right( or Range( ?

I have a "button" on the spreadsheet, that initiates this sub-routine :-

Private Sub CommandButton1_Click()
ThisWorkbook.DoIt
DoIt
End Sub

... and neither will work, to run that Subroutine that sits in the "ThisWorkbook" Page. It just tells me that "Can't find project or library".

If I go to that Subroutine, and press F8, the heading is highlighted, but again, it refuses to run, giving me that same message for words such as Right( or Range(

Not even when prefaced by "WorksheetFunction."

[romperstomper]

Check Tools - References in the VB Editor. At least one of them will be flagged as 'MISSING:' so you'll need to fix that problem.

[RobinClay]

Thank you, Rorya - that seems to solve PART of that challenge - there were several such MISSING.

I would NEVER have found that by myself !

These are the ones that ar ticked -

Visual Basic For Applications
Microsoft Excel 16.0 Object Library
OLE Automation
Microsoft Office 16.0 Object Library
Microsoft Forms 2.0 Object Library
Microsoft VBA Extensibility
Microsoft Scripting Runtime
... and my own AddIn Library

Your remedy solves the "FUNCTION" part - but, Alas ! - in the VBA Worksheet section, I have this -

Private Sub CommandButton1_Click()

ThisWorkbook.DoIt
DoIt

End Sub

... which points to a Subroutine in the "ThisWorkBook" Module - but neither command works !

"Sub or Function not defined"

[Kyle123]

Is it public?