Assign Private Sub Macro to Worksheet Shape

Hi Folks,

not sure if this is meant to be obvious but in my worksheet code module lets say I have

private macro1
private macro2


How do I assign these macros to the shapes on the actual worksheet - as they are private

Please Login or Register  to view this content.

thanks for your advice

sl

Smashing Folks,
it worked!

The small details matter

Me.Shapes("Shape2").OnAction = "Sheet2.Macro1" and not the ! in front as I had

I'll take a look at the click event too

thank you