Assigning Macro to shape in 2007 - Crash!

[ern2ern]

I posted similar yesterday. No one helped...sniff sniff (where's the crying smily)

Now verified to be occur on other machines running various versions of Office 2007...

In Excel 2007, write this simple macro and assign it to a shape:

Please Login or Register  to view this content.

My experience: Selecting shape to run macro crashes Excel. But if I just run it from the Macros dialog box or from the VB Module, it does not crash.

Is there something else special I need to do in 2007 to assign a Macro to a shape???

Do you have the same experience?

Thanks,
Ernie

[Andy Pope]

Can you post an example so we can see where the code is place and what shape you have used.

Are you using xl2007 SP1

[ern2ern]

Ok. Here it is. Thanks.

[Andy Pope]

Your test file does not crash for me.
But I will also test when I'm back at work on Monday.

[Andy Pope]

I can now reproduce the problem. It is a known bug.

Have a read of this page
http://www.rondebruin.nl/shape.htm

[ern2ern]

Andy,

Thanks man! That's the solution!

Ernie

[ern2ern]

I've also learned that if your macro ends in Thisworkbook.close and also closes other workbooks, put the macro in the other workbook and refer to it. It's not a consistent crash closing other workbooks, but it happens!

[Jongering]

I have the same problem with a piece of code that is connected to a button in Excel 2010. The RonDeBruin code doesn't solve this however. What to do?

My code is used to simply select another sheet

[arlu1201]

Jongering,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.