I have created a command button from the Excel 2003 from the Macros toolbar that I placed on my worksheet. I want to use this button to activate an existing macro. Currently I have no code entered for this button and the button when clicked on behaves as an object to be edited, moved, etc. How should I proceed?
Last edited by Dave7554; 12-20-2009 at 11:07 AM.
Did you right click on the button and select view code?
Yes, there is no code written in the button macro. The button was created after I wrote the macro.
If you would have an Active X commandbutton and you would dbl click it you would see thisAssume your macro is called macro1 and it resides in Module1 then you need to place this in between
Please Login or Register to view this content.Please Login or Register to view this content.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
I wrote the code as suggested. How do I get the button to behave correctly? It still behaves as an editable object.
Maybe check to ensure the design mode is toggled off
Thanks. That worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks