Macro button transferability

[schelber]

Hi,

I have a spreadsheet with 6 macro buttons assigned, but when i forward that spread to others , the macros are there but the buttons i created to link them does not appear for anyone else.......and they need to go in and create their own.

Same versions of excel 2002.

Any ideas on what to try?

Thanks.

 

[GlennUK]

It's not clear how you created the buttons. Did you create toolbar buttons? Did you create embedded Control Toolbox buttons in one of the sheets? Did you create embedded Forms toolbar buttons in a sheet?

 

[schelber]

sorry, didnt know there were so many forms..........i just created toolbar buttons from Tools>Customize

 

[Datsmart]

Sounds like the macros you have assigned to the buttons are saved in your "Personal.xls" file instead of the active workbook.

 

[Norie]

schelber

If you created these buttons just by going to Customize... it's unlikely they will be available to the other users.

I think there is a way to have these buttons 'travel' with the workbook, but my preferred method with this sort of thing is to programmatically create the buttons.

This can be done when the workbook is activated/opened and then the y can be removed when it's closed/deactivated.

 

[Barry Katcher]

Use the Button icon on the Forms toolbar to create your button, and send your workbook as an attachment in an email. Just did a test and it works for me. When I opened the attachment, the button was there, and it ran the attached macro.

As Norie says, putting a button on your toolbar doesn't cut it. Your customized toolbar is on your machine only, not on the recipient's. Toolbars, like fine wine, don't travel well.

 

[Datsmart]

Sorry, I mis-read your question. Thought your macros were missing, not your buttons.

I like to use AutoShapes for buttons from the Drawing Toolbar. More options for color, etc. and you can still assign macros to them. Or you could just use the standard button from the control toolbox.

 

[schelber]

thanks for all the input, i tried it andmgot it working. many thanks

 

[schelber]

hmmm. actually that didnt work......even under Forms>Button i email it to another account......bring up workbook and the button i created under Forms menu is also not there.

Wouldnt anything chosen under Customize be automatically assigned to personal.xls.........how do i create/assign a macro button under the activeworksheet so that other email recipients see the buttons i create.

Thanks.

 

[Barry Katcher]

hmmm. actually that didnt work......even under Forms>Button i email it to another account......bring up workbook and the button i created under Forms menu is also not there.

Hmm. Just a thought - Go to Tools>Options>View> and make sure "Show All" is checked under "Objects". Probably not the problem, though, since you can still see them on your own PC. Another thought - the recipient's email program may be filtering the buttons out, although they do seem to be allowing the macros.

Wouldnt anything chosen under Customize be automatically assigned to personal.xls.........how do i create/assign a macro button under the activeworksheet so that other email recipients see the buttons i create.

Where ever it's saved, it's still just on your PC, not on the recipients. The recipients don't have access to your Personal Macro book, do they?