All,
I am trying to set up a spreadsheet where each tab "belongs" to a individual, and would like to set up a "button" they can click that will grab a "signature image" from their files and insert in that spot. I have gone thru the post and was able to find the below code but it is giving me a 400 error when I try to run it.
<tbody>
</tbody><colgroup><col></colgroup>
I am trying to set up a spreadsheet where each tab "belongs" to a individual, and would like to set up a "button" they can click that will grab a "signature image" from their files and insert in that spot. I have gone thru the post and was able to find the below code but it is giving me a 400 error when I try to run it.
Sub SigButton_click() |
ActiveSheet.Pictures.Insert("C:\Users\user name\Pictures\My Pictures\Signature.JPG").Select |
ActiveSheet.Shapes.Range(Array("SigButton")).Delete |
End Sub Any Help or suggestions? John |
<tbody>
</tbody><colgroup><col></colgroup>