Is there a way to insert a background image but not have it repeat? I want to insert a single instance of an image in a sheet but have it so you can type over it. Is that possible?
I don't want the image to repeat itself over and over. I just want it to show up once. Is there any way to do that? I'm using Excel 2003.
Worst case scenario I could try increasing the size of the image and make the extra space transparent or white to blend in, but I'm looking for simpler solution.
I should mention I tried recording a macro but there is nothing recorded that would allow me to disable the "repeat" of the image.
ActiveSheet.SetBackgroundPicture Filename:= _
"C:\Documents and Settings\xxx\Desktop\bkground.bmp"
Hi, I don't know how to ensure there is only one copy , but if the image is too small to cover the sheet, you could edit the picture size with "Microsoft Editer" or similar, Save the altered image and then use that,
Sorry I can't be more helpful.
Regards Mick
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
