Accessing the intermediate window in MS Excel for mac

Hi all,

I am new to Mac, migrating from over 30 years on a PC. For that time, I became very proficient with Excel, and would like to use the spreadsheets I created on my Mac. I'm experiencing several problems with the MS ActiveX objects i put into my VBA code. I think I can eventually get those fixed, but need to access my macro code.

Specifically, I have sheets that are "very hidden", and I do not know how to access the Intermediate Window in the VBA Editor to make those sheets visible.

Any help would be greatly appreciated.

BTW, my apologies if I selected the incorrect community. I didn't see anything more specific to my question. Any guidance here would also be appreciated.