ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   remove an asigned macros (https://www.excelbanter.com/excel-discussion-misc-queries/206969-remove-asigned-macros.html)

cavalier

remove an asigned macros
 
I have assigned a macro to an object in excel 2003.
now i want to remove this assigned macro from this object (spin botton)
how can i do this

Max

remove an asigned macros
 
Right-click on spinner* Assign Macro
Press Delete to clear OK
*assume its from the forms toolbar

If you meant to remove the macro altogether, then:
Right-click Assign Macro Edit
will bring you to VBE
with the assigned macro highlighted in vbaproject
Right-click on it Remove (macro name) ...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"cavalier" wrote:
I have assigned a macro to an object in excel 2003.
now i want to remove this assigned macro from this object (spin botton)
how can i do this



All times are GMT +1. The time now is 11:33 AM.

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