Version: Excel 2003
I have set up a workbook with a master matrix on one worksheet and then about 10 other worksheets in the same file have imported bitmap images on them. My intent is to use the little camera function to take a snapshot of a cell on the master matrix page and then drag it onto one of the bitmap images on another worksheet. It seems to work a few times but then all of a sudden the bitmap just goes away. Is there a way to lock the image to the sheet but still be able to move a snapshot of the cell over the image?
I have set up a workbook with a master matrix on one worksheet and then about 10 other worksheets in the same file have imported bitmap images on them. My intent is to use the little camera function to take a snapshot of a cell on the master matrix page and then drag it onto one of the bitmap images on another worksheet. It seems to work a few times but then all of a sudden the bitmap just goes away. Is there a way to lock the image to the sheet but still be able to move a snapshot of the cell over the image?
