How Can I Quickly Add My Logo to the Top Corner of All My Worksheets?

We must update the header logos of our reports to reflect the latest corporate rebranding!

Sure! But doing it manually for 50+ worksheets spread across 5+ workbooks is not exactly a quick update…

Nor does it fall under the value-adding category to justify the time spent on manual effort.

 

There is a quick and painless way to do it with VBA, though!

 

 

But how do you know that these are the dimensions you should use for the new logo?

I don’t. I manually resized the logo to the size I wanted and then checked the dimensions by using the following code

Happy VBA coding!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.