Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
HI Does this work on browser? It doesn't work for me though. Thanks.