Macro button

[Ron99]

Hi,

I have a spreadsheet, and I have assigned a macro to a button under customize quick access toolbar, which I can see everytime I open a excel spreadsheet and it works fine.

The problem I have is - I need to send this spreadsheet to my team mates, and I want them also to get the same button under their quick access toolbar, rather than I going to their place and doing it manually, when I send them the spreadsheet I want the button to be available under quick access toolbar, is this possible ? if not, what is the alternate method.

Regards,
Ron

 

[Peter_SSs]

Put a command button in the worksheet?

 

[Ron99]

Hi,

Could you please let me know how do I go about doing it.

Thank you!

 

[Peter_SSs]

Excel version?

 

[Ron99]

I am using excel 2007.

Are you refering to insert, then we have buttons there cilck them and assign a macro ? if yes then I can do that..

but I want the buttons available in the quick acess toolbar, is that possible ?

 

[Peter_SSs]

but I want the buttons available in the quick acess toolbar, is that possible ?

No, if you are sending the sheet to another user, your sheet will not modify their Quick Access Toolbar.

I was thinking about the
Developer tab|Insert|ActiveX|Command button.

 

[Ron99]

ok...thank you!! will work on it.

I have another post subject " Need Macro Help ", if possible can you take a look..


Thank you