I am way out of my wheelhouse here but I was hoping I could get some help figuring out why I receive a "run time error 1004 unable to get OLEObjects property of the worksheet class" anytime I open a spreadsheet on my mac with excel.

My issue is after I receive this message I am unable to use the drop down boxes available on an excel document from work. It does require me to enable macros when I first open the document