Insert Picture from File - Shortcut/Macro?

  • Thread starter Thread starter twinkle17
  • Start date Start date
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!
 
---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
 
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
 
Back
Top