Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sharing macros
In an excel sheet, I assigned macros to custom buttons. Whenever I sent the
sheet to someone else, the macros were still there but the buttons were not. So, once I send it to someone, do they have to create the buttons and assign it to the macros themselves, or is there someway I can save the worksheet or custom buttons so that when the sheet is opened on another computer they are already there? Do macros assigned to shortcut keys work the same way (i.e. they would only work on my computer)? Sorry if this has been asked before. I searched before I posted and couldn't find anything that related to this. |
#2
|
|||
|
|||
Create an addin and put the code in there, and install on all users
machines. -- HTH RP (remove nothere from the email address if mailing direct) "fabulousk" wrote in message ... In an excel sheet, I assigned macros to custom buttons. Whenever I sent the sheet to someone else, the macros were still there but the buttons were not. So, once I send it to someone, do they have to create the buttons and assign it to the macros themselves, or is there someway I can save the worksheet or custom buttons so that when the sheet is opened on another computer they are already there? Do macros assigned to shortcut keys work the same way (i.e. they would only work on my computer)? Sorry if this has been asked before. I searched before I posted and couldn't find anything that related to this. |
#3
|
|||
|
|||
I also found some other questions on the matter and found some details on
adding a custom toolbar. However, when I send the excel sheet through email, the custom toolbar is attached, but it is not assigned to the correct macros. Guess I'll keep messing with it until either it works or I've gone crazy. Thanks for the input! K "Bob Phillips" wrote: Create an addin and put the code in there, and install on all users machines. -- HTH RP (remove nothere from the email address if mailing direct) "fabulousk" wrote in message ... In an excel sheet, I assigned macros to custom buttons. Whenever I sent the sheet to someone else, the macros were still there but the buttons were not. So, once I send it to someone, do they have to create the buttons and assign it to the macros themselves, or is there someway I can save the worksheet or custom buttons so that when the sheet is opened on another computer they are already there? Do macros assigned to shortcut keys work the same way (i.e. they would only work on my computer)? Sorry if this has been asked before. I searched before I posted and couldn't find anything that related to this. |
#4
|
|||
|
|||
K,
Make sure that you attach it to the workbook. Do this by going to the View menu, choose Tool Bars, then Customize. In that dialog, select the Toolbars tab and click Attach. Select your command bar in the left side list box and click Attach -- HTH RP (remove nothere from the email address if mailing direct) "fabulousk" wrote in message ... I also found some other questions on the matter and found some details on adding a custom toolbar. However, when I send the excel sheet through email, the custom toolbar is attached, but it is not assigned to the correct macros. Guess I'll keep messing with it until either it works or I've gone crazy. Thanks for the input! K "Bob Phillips" wrote: Create an addin and put the code in there, and install on all users machines. -- HTH RP (remove nothere from the email address if mailing direct) "fabulousk" wrote in message ... In an excel sheet, I assigned macros to custom buttons. Whenever I sent the sheet to someone else, the macros were still there but the buttons were not. So, once I send it to someone, do they have to create the buttons and assign it to the macros themselves, or is there someway I can save the worksheet or custom buttons so that when the sheet is opened on another computer they are already there? Do macros assigned to shortcut keys work the same way (i.e. they would only work on my computer)? Sorry if this has been asked before. I searched before I posted and couldn't find anything that related to this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Macros disappear after a file is imported | Excel Discussion (Misc queries) |