Screen 2 SNAPSHOT is it possible

[colbecd]

Hi all

I know its possible for VBA code to be made to take a snap shot of your desktop however i have to screens at work and only want the snap shot of screen 2 does anyone know if this is even possible?

Thanks in advance!
Dan

 

[MUKESHY12390]

I think excel Vba allow to snapshot only in excel workbook..

 Sub snap()


    Range("C6").Select ''' U can exapand Range here
    Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture
    ActiveSheet.Paste
    
End Sub

other than this... there is 2 sortkey for Windows user

1- Ctrl+Print scrn

2- Ctrl+alt+print scrn -- Only for active window



Hope it will help you...