Does ScreenUpdating affect the CopyPicture method?

I am using a macro in one of my documents that unhides a specific worksheet, copies a range to the user's clipboard as a bitmap image, and returns to the to the sheet that was active when the macro was executed.

Running the macro while Application.ScreenUpdating = True does exactly what I want it do and I am able to paste the picture with a simple CTRL+V once the macro is finished. I don't, however, want the user to see what is happening when they click the button that triggers the macro so I added Application.ScreenUpdating = False as the first line of the macro and Application.ScreenUpdating = True as the last line of the macro.

This accomplishes the desired effect of not showing the user what is happening behind the scenes, but it pastes a blank picture when I press CTRL+V after the macro has been executed.

Any thoughts?

My code is below:

Please Login or Register  to view this content.

Here's the workbook. Run the macro (copyRaceEthnicityChart) with the "Outputs" sheet (which will be hidden when you open the file) activated and it should paste a blank chart when you press CTRL+V.

Affordable Housing Forecast Tool.xlsm