VBA IF Statement: IF table in sheet is called THEN....

Hi All

I'm doing a bit of data validation and would like to prevent the user from running a macro if the table name is not correct on sheet1.

Sheet1 only contains 1 table and it must be named 'thebesttable' before they continue

I've tried to modify the code from here
https://stackoverflow.com/questions/...ing-table-name

Please Login or Register  to view this content.

But I'm getting the following error

VBA Error.png

Any advice appreciated
All the best
Vicky

Works perfectly thank you