Taking Screenshots

[#1]

Hello

Is there anyway I could add a button and assign a action to take the screenshot of current sheet?

I know this is available out of the box by right clicking on sheet and selecting "Copy Image to Clipboard" but wondering if I could assign this to a button?

Many Thanks

[Gysbert_Wassenaar · Accepted solution]

You could create a macro for this

Sub ShootScreen

     ActiveDocument.ActiveSheet.CopyBitmapToClipboard

End Sub

You can add a Run Macro action to the button to run the macro the button is clicked.

[#3]

HI Does this work on browser? It doesn't work for me though. Thanks.