Hello Everyone!

I have a question that I'm not sure is possible to achieve.

I have a Dashboard Workbook with the following 10 sheets (by name):

  • Dashboard
  • Measure Definitions
  • Data Entry
  • Action Plan
  • Reporting
  • 1
  • 2
  • 3
  • 4
  • Update

Every one of these sheets has the same logo on it. It's dimensions (if that is important) is a height of 1.25 inches and a width of 2.14 inches.

Is there a way to set up a macro whereby all the logos can be changed at once to another logo/image?

This dashboard will likely be used by personnel from several different companies/agencies, and I want to see if I can make swapping out the logo easy, rather than them having to manually do it 10 or more times (there are two of the same logo on the Reporting tab, one next to the navigation buttons and one in the print-able area). Even if it can only be achieved with the 10 in the navigation menu, that's more than fine with me.

Is it possible to replace all images without affecting charts or inserted shapes that are on each sheet?

If it is possible, I'd like to arrange it so they can put a file named "logo" in a folder named "PM Dashboard." When you press the associated button, it uses this file location to insert that image in place of all the others. I would put this button on the "Update" worksheet if that is relevant to the VBA code.

If this is not possible, I guess they will simply be out of luck as far as getting the easy way out of logo replacement.

Thanks in advance!

-LM