View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Pelarian Pelarian is offline
external usenet poster
 
Posts: 2
Default Adding picture to page setup

Sorry it took me so long to reply to you. I am running Office 2k3 both
at work and at home. so yes I can see this could be an issue.
I did a little research on Google and found this information at
http://www.exceltip.com/st/Adding_a_...ooter/202.html
A really good place to look around and ask for assistance. I have also
read one of their books and found their information on VBA in Excel
invaluable. Below you will find an excert from the web page that I
listed above. Also here is the text that I typed in to google.com to
search for information on your question..."add a picture to Excel 2000
header". Hopefully this will help you out a little more that what I
gave you before.

{Quoted from ExcelTip.com}
To add a picture (such as a company logo) to the header/ footer in
Excel 97 and Excel 2000:

1. Select cell A1.
2. From the Insert menu, select Picture, and then select From File.
3. Select the picture you want, and click Insert.
4. Adjust the picture to the height and width of the row.
5. From the File menu, select Page Setup.
6. Select the Sheet tab.
7. Select Rows to repeat at top.
8. Select row 1, and then click OK.

While doing these steps you should be able to AFTER doing them a time
or three <grin be able to turn the macro recorder on and then after
doing the steps be able to get the code from there.

Feel free to send me an email (please look at my profile to retrieve
the email address)

Regards,
Pelarian