OK bear with me I am literally brand new today to this stuff.
I've designed a worksheet (for work) in which the user needs to be able to insert a picture of their choice in a specified place.
I need this to be able to be done in 4 places on the sheet.
I've been googling and found the below script which works when you play it but wont work on the Ctrl +1 command.
Can any one tell me what i'm doing wrong?
Each Macro is the same but for a different place
Sub Macro1()
' Keyboard Shortcut: Ctrl1
Const PW As String = ""
ActiveSheet.Unprotect Password:=""
Range("$g$31").Select
Application.Dialogs(xlDialogInsertPicture).Show
ActiveSheet.Protect Password:=""
End Sub
Sub Macro2()
' Keyboard Shortcut: Ctrl+2
Const PW As String = ""
ActiveSheet.Unprotect Password:=""
Range("$g$41").Select
Application.Dialogs(xlDialogInsertPicture).Show
ActiveSheet.Protect Password:=""
End Sub
Sub Macro3()
' Keyboard Shortcut: Ctrl+3
Const PW As String = ""
ActiveSheet.Unprotect Password:=""
Range("$g$51").Select
Application.Dialogs(xlDialogInsertPicture).Show
ActiveSheet.Protect Password:=""
End Sub
Sub Macro4()
' Keyboard Shortcut: Ctrl+4
Const PW As String = ""
ActiveSheet.Unprotect Password:=""
Range("$g$61").Select
Application.Dialogs(xlDialogInsertPicture).Show
ActiveSheet.Protect Password:=""
End Sub
Bookmarks