How to form jpeg from Ctrl-Shift-PrintScreen?

I suggest you test as follows before introducing into your file
- download the attached file
- navigate to VBA editor Module1
- amend constant fPath to a valid path on your computer - end with "\"
- do not alter anything else
- then run with {CTRL} k
- screen image is grabbed and saved with unique file name
- message informs user with file name and path
(cell colours change randomly so that I could see that each image was different when testing)

Please Login or Register  to view this content.