I am currently using Excel 2010 VBA to copy a worksheet containing an image from one workbook to the other. The image of the copied worksheet, however, cannot be properly displayed and an error "This image cannot currently be displayed" appear in the image placeholder instead. After a bit of testing, it turns out that the image would fail to copy properly if both of the following conditions are met:
1. The Application.ScreenUpdating is FALSE; and
2. Both the source and the target workbooks do not contain the VBA code ("ThisWorkbook") to be run.
In my case, I have to turn ON the Application.ScreeenUpating during the sheet-copy process in order to get around the problem. Obviously however, it is not desirable. Is there any workaround while I can properly copy the sheet containing images AND without the need to turn on the ScreenUpating (other than moving the source worksheets to ThisWorkbook)? Please advise.
1. The Application.ScreenUpdating is FALSE; and
2. Both the source and the target workbooks do not contain the VBA code ("ThisWorkbook") to be run.
In my case, I have to turn ON the Application.ScreeenUpating during the sheet-copy process in order to get around the problem. Obviously however, it is not desirable. Is there any workaround while I can properly copy the sheet containing images AND without the need to turn on the ScreenUpating (other than moving the source worksheets to ThisWorkbook)? Please advise.
