my command button in excel does'nt work 1

[gem28]

Hi! I have embedded a command button within my excel worksheet and have incorporated the macro, I recorded earlier (with a keybord shortcut earlier), in it but it does not work. It does not even click! Pls. help me!

Thanks.

 

[BrainB]

What sort of Command Button ? From Forms Toolbar or Control Toolbox ?
Does your macro run at all ? - Try putting a Breakpoint or Stop command into it and clicking the button. Regards
BrianB
** Let us know if you get something that works !
================================

 

[gem28]

From the Control toolbox and yup, the macro works but I don't understand why it does'nt work on the button. What are the complications if I copy the code from the module to the private sub of the command button?

 

[xlbo]

Have you come out of design mode ?? Rgds
~Geoff~

 

[glenntb]

Many times this can be caused by the button taking the application's focus. Try changing the "TakeFocusOnClick" property of the command button to FALSE. (To do this, right click on your command button, and select the "Properties" option from the shortcut menu.)

Hope this helps!

-Glenn

 

[BrainB]

I suggest you use the button from the Forms Toolbox, even though it has less properties. The Control toolbox is really for custom user forms.

Regards
BrianB
** Let us know if you get something that works !
================================

 

[gem28]

Thank you all for your responses. Truly appreciated.
I have already resolved the problem with the button. I am trying to work around with VBA for Excel and so far... so good... I have this scenario, I need to click on a button so that the data in the active sheet can be sorted and transfered immediately to another worksheet, what I did, I set the focus on the active sheet and copied the data then set the focus on the other sheet.

I now have problems selecting the data of the other sheet so I can highlight all the data and paste the entries I copied from the other sheet. I used macro for this but some functions and properties do not work. Pls. help me. Thanks! :>

~Tin~