dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,375
- Office Version
- 365
- 2016
- Platform
- Windows
I have code that puts an image in the right spot. Could someone help me with the code that allows you to insert your own image and put it in the same spot please?
This is the code that puts the set image in the right spot.
This is the code that puts the set image in the right spot.
Code:
Sub cmdGarrettSig()
Dim shp As Shape
Set shp = Sheets("NPSS_quote_sheet").Shapes("textbox_2")
Sheets("Sheet2").Shapes("ImgG").Copy
Sheets("NPSS_quote_sheet").Paste Destination:=Sheets("NPSS_quote_sheet").Cells(1, 1)
Selection.Top = shp.Top + shp.Height + "50"
'ActiveSheet.Protect Password:="npssadmin"
End Sub