VBA macro for external pictures will not run on a Mac with MS365

%3CLINGO-SUB%20id%3D%22lingo-sub-1637792%22%20slang%3D%22en-US%22%3EVBA%20macro%20for%20external%20pictures%20will%20not%20run%20on%20a%20Mac%20with%20MS365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1637792%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20someone%20write%20a%20macro%20so%20that%20we%20could%20pull%20in%20pictures%20of%20styles%20from%20our%20website%20picture%20database%20when%20we%20enter%20the%20style%20number.%20%26nbsp%3BIt%20works%20on%20a%20pc.%20%26nbsp%3BOn%20my%20Mac%20(Running%20Catalina)%20with%20MS%20Excel%20365%20ver%2016.4%20%26nbsp%3Bthe%20macro%20runs%20but%20nothing%20shows%20up%20in%20the%20picture%20box.%20%26nbsp%3BCan%20anyone%20help%20me%20figure%20out%20what%20needs%20to%20happen%20in%20order%20to%20run%20on%20a%20mac.%20I%20was%20reading%20that%20some%20version%20of%20Excel%20on%20a%20mac%20are%20not%20able%20to%20access%20external%20files%2C%20but%20I%20am%20not%20sure%20how%20to%20fix%20that.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1637792%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I had someone write a macro so that we could pull in pictures of styles from our website picture database when we enter the style number.  It works on a pc.  On my Mac (Running Catalina) with MS Excel 365 ver 16.4  the macro runs but nothing shows up in the picture box.  Can anyone help me figure out what needs to happen in order to run on a mac. I was reading that some version of Excel on a mac are not able to access external files, but I am not sure how to fix that. 

 

Thanks 

 

0 Replies