• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to change Header Picture?

C

cmissal

New Member
I have done extensive research, and the only thing I seem unable to do to completely format my print page headers using VBA is insert a picture. Ideally I could select an picture object (or cell range) that my end user inserts in a setup worksheet.


Does any know a work around for this? I am using Excel 2007.


Thanks!

Casey
 
The picture needs to be an existing file...maybe somehow you can detect what picture is desired and use that to choose which file to get? VBA to insert picture in header is something like:

ActiveSheet.PageSetup.LeftHeaderPicture.Filename = _

"C:My DocumentsMy PicturesChandoo.bmp"
 
You must log in or register to reply here.
Back
Top