Image Button issue

[harryco79]

Hello Gurus

I have an image in my excel sheet that i trying to use as a button.

I know how to assign a macro to an image/shape (Right-click / Assign Macro). This works well for macros in modules.

But i cant seem to attach a private Sub macro in the worksheet module.

the image is in the same worksheet that has the macro.

Any thoughts / recommendations?

Thanks

 

[harryco79]

 

[just_jon]

If you're trying to assign CommandButton1_Click to an image, you can't.

Change it to a regular sub, ex.: Sub foo()