Selecting the Toolbar components.

[gajendra.gupta]

Hi Group,

I working on some existing Excel application. In this application I have some command buttons on different worksheets. I want to select these command button on worksheet in design mode but I am not able to do so. What is wrong with which I am following?

I am selecting 'Design Mode' from 'Control toolbox toolbar' and then trying to select the command button. But instead of showing its properties and etc, it is functioning based on its written source code.

Please help me out how can I select it as I want to know that which macro has been assigned to it.

Regards,
Gajendra Gupta

[antoka05]

Try so:

choose menu 'Tools' then 'Personalize' (I hope this is the label... I use excel in a language different from english).

Then click with the right mouse button on your icon and choose 'assign macro'.

I hope it can help you.

Regards,
Antonio

[gajendra.gupta]

No, it is not there but I beleive the same label I have, is 'Customize'. It does not help you out actually because until and unless you do not select that command button you can not 'Personlize' it.

Regards,
Gajendra Gupta

[antoka05]

I think you may try with vba (this code will put in your active sheet cells the macro called for each command in your bar):

Please Login or Register  to view this content.

I hope it can help.

Regards,
Antonio