Inserting a picture into a protected worksheet into Excel using Macros

[MRSAFR]

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

Please Login or Register  to view this content.

[efernandes67]

Comparing the different "Keyboard Shortcuts",

Macro1 -> ' Keyboard Shortcut: Ctrl1 - does not have the '+' sign
Macro2-> ' Keyboard Shortcut: Ctrl+2
Macro3-> ' Keyboard Shortcut: Ctrl+3
Macro4-> ' Keyboard Shortcut: Ctrl+4

Maybe you need to redefine the keyboard shortcut for macro1.

Elio Fernandes

[MRSAFR]

Sorry that was my mistake, it didn't work with the "+" sign so I removed it to see if it worked without it but it didn't.

I know the script is correct as it runs, is there anything I need to do like press some button to apply it to the excel sheet?

[efernandes67]

Can you post your file?

[MRSAFR]

Attached is my worksheet

[MRSAFR]

Done it - had to assign the macro to an object. It works now,

Thanks any way