| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro and custom Button
Hello Last year I created a macro and assigned custom button to the macro.
I have to edit this macro and I forgot the name of the macro. How do I find out which macro is attached to this custom button/ Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro and custom Button
Try: right click on the button and then "Assign Macro": this should show
which macro is currently assigned. "Wanna Learn" wrote: Hello Last year I created a macro and assigned custom button to the macro. I have to edit this macro and I forgot the name of the macro. How do I find out which macro is attached to this custom button/ Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro and custom Button
Toppers THanks but If I right clik on the button I get a menu with tool
bars names , e.g. standard, formatting, borders, chart, nothing that says "Assign macro" "Toppers" wrote: Try: right click on the button and then "Assign Macro": this should show which macro is currently assigned. "Wanna Learn" wrote: Hello Last year I created a macro and assigned custom button to the macro. I have to edit this macro and I forgot the name of the macro. How do I find out which macro is attached to this custom button/ Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro and custom Button
Sorry ... I now realise your button is on a toolbar. Looking through my Excel
"Bibles" I cannot see any obvious way to determine the macro although I guess this can be done (somehow!) using VBA. What happens (or should) when you click your button - can you cause it to fail and use this to identify the macro? A bit crude but might work! "Wanna Learn" wrote: Toppers THanks but If I right clik on the button I get a menu with tool bars names , e.g. standard, formatting, borders, chart, nothing that says "Assign macro" "Toppers" wrote: Try: right click on the button and then "Assign Macro": this should show which macro is currently assigned. "Wanna Learn" wrote: Hello Last year I created a macro and assigned custom button to the macro. I have to edit this macro and I forgot the name of the macro. How do I find out which macro is attached to this custom button/ Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro and custom Button
use <view<toolbars<custom
now when you right click on the button it will show the assign macro line "Toppers" wrote: Sorry ... I now realise your button is on a toolbar. Looking through my Excel "Bibles" I cannot see any obvious way to determine the macro although I guess this can be done (somehow!) using VBA. What happens (or should) when you click your button - can you cause it to fail and use this to identify the macro? A bit crude but might work! "Wanna Learn" wrote: Toppers THanks but If I right clik on the button I get a menu with tool bars names , e.g. standard, formatting, borders, chart, nothing that says "Assign macro" "Toppers" wrote: Try: right click on the button and then "Assign Macro": this should show which macro is currently assigned. "Wanna Learn" wrote: Hello Last year I created a macro and assigned custom button to the macro. I have to edit this macro and I forgot the name of the macro. How do I find out which macro is attached to this custom button/ Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Invoking a Visual Basic macro from a Custom Toolbar Button | Excel Worksheet Functions | |||
| Export custom Macro Button Images | Setting up and Configuration of Excel | |||
| Export custom Macro Button Images | Excel Discussion (Misc queries) | |||
| Macro or Custom button to fill in the same formula | Excel Worksheet Functions | |||
| Send a custom button/macro to others? | Excel Discussion (Misc queries) | |||
Hybrid Mode
