CopyPicture isn't working when the PC is standby

[arimateiab]

Hello,

The following line of code
Area.CopyPicture Appearance:=xlScreen, Format:=xlPicture

Doesn't work when the computer enters in standby mode.

Can anyone help me?

Thanks!!

 

[arimateiab]

Up

 

[arimateiab]

up

 

[daverunt]

Hi,

you mean the PC is in screen saver mode?

xlScreen copies the picture as it is on screen as far as I know so I would have thought that would be the problem.
Turn off your screensaver?

https://www.excelforum.com/excel-programming-vba-macros/537584-stop-a-running-screensaver.html

 

[arimateiab]

Hello daverunt!

I mean when I press Windows Key + L...

Thanks.

 

[daverunt]

I've never used this function but suspect you can't use xlScreen if the picture isn't showing for whatever reason, screensaver, lock out.
All I can suggest is try xlPrinter instead.