add click effect to autoshape

[kents86]

hi all!

Just quick question.

Is it possible to add "click" effect to autoshape ?


I googled it, but no result


Thanks for any help

[teylyn]

Hello,

please update your profile to indicate what version of Excel you are using. This will make it a lot easier to provide answers that you can actually use in your version.

Normally, you should be able to right-click the shape and select "assign macro". For this, you would have to write or record a macro in the first place, though.

cheers,

[kents86]

Hi,

thanks, ill update profile.

I am using 2007 version.


But I will rephrase question. What I whant to find out is, can I somehow generate that button click effect to autoshape created object (button)

click like from VB tools button.

Resuklt would be, my desired macro executes & autoshape beautifully clicks before execution.

[Andy Pope]

If you add a Bevel autoshape you can use a couple of lines of code around your actual macro code to simulate button press.

Please Login or Register  to view this content.

If the auto shape is not a bevel then some other formatting will be required to generate the effect.