ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Button - Assigned Macro (https://www.excelbanter.com/excel-programming/429041-button-assigned-macro.html)

Richard

Button - Assigned Macro
 
Is it possible to change the macro that is assigned to a button. Although it
would be easy enough to delete the existing button and create a new one, with
the correct macro assigned, that wouldn't seem to me to be the best method
opf handling this situation.

Jacob Skaria

Button - Assigned Macro
 
Right click the shape Assign Macro
Remove the Macro name field. Click OK

If this post helps click Yes
---------------
Jacob Skaria


"Richard" wrote:

Is it possible to change the macro that is assigned to a button. Although it
would be easy enough to delete the existing button and create a new one, with
the correct macro assigned, that wouldn't seem to me to be the best method
opf handling this situation.


Richard

Button - Assigned Macro
 
there's the issue then, my right click isn't working. I have hyperion
essbase installed, which is giving a few issues. Ho Hum.

thanks for the advice

"Jacob Skaria" wrote:

Right click the shape Assign Macro
Remove the Macro name field. Click OK

If this post helps click Yes
---------------
Jacob Skaria


"Richard" wrote:

Is it possible to change the macro that is assigned to a button. Although it
would be easy enough to delete the existing button and create a new one, with
the correct macro assigned, that wouldn't seem to me to be the best method
opf handling this situation.


Dave Peterson

Button - Assigned Macro
 
Jim Thomlinson posted this...

Essbase - Options - Global - Uncheck "Enable Secondary Button"

This is a wonderful feature that allows you to pivot your essbase data by
dragging and dropping the members between rows and columns. The problem is
that it takes over your ability to right click.





Richard wrote:

there's the issue then, my right click isn't working. I have hyperion
essbase installed, which is giving a few issues. Ho Hum.

thanks for the advice

"Jacob Skaria" wrote:

Right click the shape Assign Macro
Remove the Macro name field. Click OK

If this post helps click Yes
---------------
Jacob Skaria


"Richard" wrote:

Is it possible to change the macro that is assigned to a button. Although it
would be easy enough to delete the existing button and create a new one, with
the correct macro assigned, that wouldn't seem to me to be the best method
opf handling this situation.


--

Dave Peterson


All times are GMT +1. The time now is 02:50 PM.

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