Hi Folks
I wonder if you can help me with this issue.
I have a fairly elaborate excel programme which, using vba, opens a background image each time a worksheet is open (it helps give a corporate feel and less of an excel feel to the programme). We use code to do this so that the image is only present when a worksheet is open, therefore limitimg system resource usage as there can be several sheets to a workbook and several workbooks open at any one time. (therefore if there are 4 workbooks open at the same time, there are only 4 sheets with the background image rather 4 x the number of sheets per workbook)
However, as the image is tiled on each worksheet for the entire width and height of the sheet the image is actually loaded many many times. Is there any way via code that this image is only loaded in the top left of the sheet as this is the only area the user views as opposed to being tiled all over the sheet??
Thanks in advance
Derek