Macro button transferability

schelber

Board Regular
Joined
Oct 22, 2005
Messages
172
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.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
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

Board Regular
Joined
Oct 22, 2005
Messages
172
sorry, didnt know there were so many forms..........i just created toolbar buttons from Tools>Customize
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Sounds like the macros you have assigned to the buttons are saved in your "Personal.xls" file instead of the active workbook.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,057
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
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

Well-known Member
Joined
Jun 19, 2003
Messages
7,985

ADVERTISEMENT

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

Board Regular
Joined
Oct 22, 2005
Messages
172
thanks for all the input, i tried it andmgot it working. many thanks
 

schelber

Board Regular
Joined
Oct 22, 2005
Messages
172
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

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
schelber said:
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.

schelber said:
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,381
Messages
5,571,804
Members
412,420
Latest member
Quintankerus
Top