View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Insert Picture from File - Shortcut/Macro?

---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/communities...&lang=en&cr=US


If this post helps click Yes
---------------
Jacob Skaria


"twinkle17" wrote:

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!