Get details of a Background Image applied to a sheet in excel
Hi,
I need to know a way to get the details of image that is applied as Background Image to a particular sheet and apply the same image as background to other sheets using VBA.
Thanks in advance
I need to know a way to get the details of image that is applied as Background Image to a particular sheet and apply the same image as background to other sheets using VBA.
Thanks in advance
ASKER
@Rgonzo1971,
Alright, but can we store that picture in a sheet and then apply to other sheets, because it is possible that when the workbook is distributed then the image file is not distributed or is deleted, then the background image wont be applied.
Alright, but can we store that picture in a sheet and then apply to other sheets, because it is possible that when the workbook is distributed then the image file is not distributed or is deleted, then the background image wont be applied.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@Rgonzo1971,
How to implement the above code? When I try i get the error The index into the specified collection is out of bounds. at the code Set shp = ws.Shapes(1)
How to implement the above code? When I try i get the error The index into the specified collection is out of bounds. at the code Set shp = ws.Shapes(1)
do you have an image not a backgroundpicture in the sheet BImage
ASKER
The same is working. It was my mistake I was trying the same as background picture. But this opens a Powerpoint, is there a way without opening a Powerpoint, or atleast hiding the whole process of opening the powerpoint
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
AFAIK it is not possible with VBA to read the Background Picture property
Regards