#BLOCKED! Error and cannot figure it out!

[bbbb1234]

I have setup a Define Name formula to get the name of tabs in a workbook as follows:

Define Name: GetNames​

Formula used in Define Names: =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")​

I was using this sheet on a Mac and it worked fine.
I opened it up on a PC and get the #BLOCKED! error as noted in the tab capture below
Here is the PC Config

OS: Microsoft Windows 10 Home​

Version: 10.0.19044 Build 19044​

Excel & Office version: Microsoft 365​

1.Harvey Excel Files 2022-01-26 1955.xlsm
	A	B	C	D	E
1	Index	SheetName	Link	MAX ROW	MAX COL
2	1	#BLOCKED!	#BLOCKED!
3	2	#BLOCKED!	#BLOCKED!	#BLOCKED!	#BLOCKED!
4	3	#BLOCKED!	#BLOCKED!	#BLOCKED!	#BLOCKED!
5	4	#BLOCKED!	#BLOCKED!	#BLOCKED!	#BLOCKED!
6	5	#BLOCKED!	#BLOCKED!	#BLOCKED!	#BLOCKED!
7	6	#BLOCKED!	#BLOCKED!	#BLOCKED!	#BLOCKED!
8	7	#BLOCKED!	#BLOCKED!	#BLOCKED!	#BLOCKED!
TabList

Cell Formulas
Range	Formula
A2:A8	A2	=ROW()-1
B2:B8	B2	=INDEX(SheetNames,A2)
C2:C8	C2	=HYPERLINK("#'"&B2&"'!A1",B2)
D3:D8	D3	=MAX(IF(INDIRECT("'"&$B3&"'!A1:ZZ5000")<>"",ROW($A$1:$ZT$5000)))
E3:E8	E3	=MAX(IF(INDIRECT("'"&B3&"'!A1:Zz5000")<>"",COLUMN($A$1:$ZT$5000)))

Why am I getting the #BLOCKED! error?

 

[Alex Blakenburg]

Get.Workbook is a Excel 4.0 (XLM) Macro and is now being blocked by default. You need to enable it in your trust settings.
File > Options > Trust Center > Trust Center Settings > Macro Settings
Turn on Enable Excel 4.0 macros when VBA macros are enabled.
Start with that, you may need to do more.

Working with Excel 4.0 macros - Microsoft Support

Although Microsoft Excel still supports Excel 4.0 (XLM) macros, we encourage you to migrate them to the latest version of Microsoft Visual Basic for Applications (VBA). Migrating your macros lets you take advantage of the improvements to the VBA programming object model. If you decide you’re not...

support.microsoft.com

 

[bbbb1234]

Alex - This worked!! Thanks so much!!

 

[Alex Blakenburg]

You're welcome. Glad I could help.

 

[vanderplas.bart]

Thank you Alex, this helped me too.