Run macro from shape when runnig macro in Excel 2007

[bren]

Hi,

I´m recording a macro that tries to run a macro from a shape, but it
doesn´t work in Excel 2007. I don´t know if this is a problem of this
version because I could do it in 2003.

Thanks

 

[Gary''s Student]

Make sure the macro you have assigned to the shape is a public sub in a
standard module:

Sub Picture1_Click()
'
' Picture1_Click Macro
'
' Keyboard Shortcut: Ctrl+e
'
Range("G3").Select
ActiveCell.FormulaR1C1 = "1"
Range("G4").Select
End Sub

Sub dural()
Call Picture1_Click
End Sub

 

[bren]

Hi,

It already creates it on a standard module and it´s public and it doesn
´t seem to work when I´m recording a macro and I try to click on the
shape to run the macro assigned to it. Your example seems to been made
with a picture and it works fine with pictures but not with shapes.
Any ideas?

Thank so much for your help.

 

[Herbert Seidenberg]

Excel 2007 Shapes
Macro
http://c0444202.cdn.cloudfiles.rackspacecloud.com/12_05_09.xlsm
http://www.mediafire.com/file/zijv0rhawzw/12_05_09.xlsm

 

[bren]

Excel 2007 Shapes
Macrohttp://c0444202.cdn.cloudfiles.rackspacecloud.com/12_05_09.xlsmhttp://www.mediafire.com/file/zijv0rhawzw/12_05_09.xlsm

Hi, I´m trying to run the macro of the files that you have posted here
and Excel 2007 doesn´t let me run it when I´m recording a macro with
the macro recorder as I asked. Does someone know if this is an Excel
2007 fake?

Thank you.