Macro which captures screen prints of the screen when the sheet is completely minimized

dimppal

New Member
Joined
May 14, 2016
Messages
1
Hi,

There is a requirement where we need an excel macro which captures the screen prints of the screen using keyboard combinations( lets say CTRL + D) and align those screen prints vertically one by one in the excel sheet itself.

The requirement is completely built i.e. macro is capturing screen prints and aligning it properly and paste it in the sheet. but currently we a facing an problem with the macro.

The problem is that the key combination (i.e. CTRL+D) does not work when the excel sheet is completely minimized.

Currently there is a limitation on the excel macro sheet is user needs keep the sheet open for capturing the screen prints and hence results in capturing excel sheet's prints as well in the screenshot.

I need to know what can i do to my code so that the key combination will work even when the sheet is completely minimized.


Thanks in advance.
Dimple
 

We've detected that you are using an adblocker.

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.
Go back
Back
Top