Insert Picture from File - Shortcut/Macro?

T

twinkle17

I want to create a shortcut/macro/menu button to insert our company logo to
Excel documents. The logo is a .jpg saved to the desktop.

Can anyone help?

Also, how do I view all my questions that I've posted in discussion groups?
There is one I can't find.

Thankyou!
 
J

Jacob Skaria

---Try the below

Sub Macro1()
Dim strFile As String
strFile = "path and filename here"""

'If you are looking at inserting to the sheet
ActiveSheet.Pictures.Insert (strFile)

'OR Insert the log as a page header..
ActiveSheet.PageSetup.RightHeaderPicture.Filename = strFile

End Sub


----If you are using the web interface..

-For this question; on the right panel where you see the question
description clik on the name link (twinkle17) which brings up your
profile.

-From the profile window hit the link 'Recent Posts by this User' to see
your posts..

http://www.microsoft.com/communitie...cef-6aac-414e-9881-2ba33de8be2f&lang=en&cr=US


If this post helps click Yes
 
A

AJB

Jacob - I was trying to do this same thing yesterday, but am not having much
luck. My goal is to get jpg files as the background in comments. Debra
Dalgleish has a few macros that are promising for me, but I need to get the
jpg file into the excel document first.

http://www.contextures.com/xlcomments03.html

I would be trying to get different pictures in everytime (i am in
construction and am trying to provide reference pictures for certain items of
my scope of work).

thanks so much,

Andy
 
Top