ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Remove macro from autoshape (https://www.excelbanter.com/excel-programming/321358-remove-macro-autoshape.html)

DEE

Remove macro from autoshape
 
Hi,

I right-clicked and assigned a macro to an autoshape, but now wish to remove
it and can't figure out how.

I know I can just delete the autoshape and re=create it, but want to
understand this.
--
Thanks!

Dee

Harald Staff

Remove macro from autoshape
 
Do the "assign macro" thing again and clear the macro name from the dialog.

HTH. Best wishes Harald

"dee" skrev i melding
...
Hi,

I right-clicked and assigned a macro to an autoshape, but now wish to

remove
it and can't figure out how.

I know I can just delete the autoshape and re=create it, but want to
understand this.
--
Thanks!

Dee




Jimbola

Remove macro from autoshape
 
Right-click the autoshape click assign macro, and clear the macro name, and
press OK.


"dee" wrote:

Hi,

I right-clicked and assigned a macro to an autoshape, but now wish to remove
it and can't figure out how.

I know I can just delete the autoshape and re=create it, but want to
understand this.
--
Thanks!

Dee


DEE

Remove macro from autoshape
 
Hi All,

Thanks and PLEASE excuse my complete and total stupidity. How obvious. I
apologize. End of a long week and my blond is coming out!

"Harald Staff" wrote:

Do the "assign macro" thing again and clear the macro name from the dialog.

HTH. Best wishes Harald

"dee" skrev i melding
...
Hi,

I right-clicked and assigned a macro to an autoshape, but now wish to

remove
it and can't figure out how.

I know I can just delete the autoshape and re=create it, but want to
understand this.
--
Thanks!

Dee





Harald Staff

Remove macro from autoshape
 
"dee" skrev i melding
...
Thanks and PLEASE excuse my complete and total stupidity. How obvious. I
apologize. End of a long week and my blond is coming out!


Don't apologize. Nothing is obvious until one knows the solution. People
have struggled with un-assigning macros in the past and will struggle next
year too. Your posting benefints the readers and the archives.

Best wishes Harald




All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com