Quote Originally Posted by jolivanes View Post
"critical spreadsheet that we call SHIPPER" & "primary sheet". Are these the same sheets?
"separate sheets". What are these named? Or are this the 14 tabs? If so, are these tabs the only tabs in the workbook? If not, where are they situated? The last 14? Or maybe the first leftmost 14?
"with 5-6 private labels" Where does this come in with your problem to be solved? Where do we need to watch for this?
"go into each workbook" Which workbooks are that?
"this spreadsheet" Which sheet is that?
"a Macro or is there other more modern ways" How old are your macros if they are compared to "more modern ways"
BTW, what do you consider "more modern ways?


Or is it that you want to select a picture from FileDialogFilePicker, insert it in every sheet in the active workbook and size it to cover A1:C10?
Shipper is the name of the entire project...I should have said on each Worksheet (Not Primary SHeet), there is a logo...there are 14 tabs/worksheets. They have unique names.

The file picker will help the user find the private label JPG.

Again, sorry...only one workbook...should have said worksheet.

Well, not sure if I could use Office Scripting or that new feature that came out but this SHIPPER is so VBA heave, that I might as well keep it.

So, I tried the code ARNELGP provided and it gets stuck on the shape reference.