Transferring custom excel ribbons in local computer to other computers in Excel 2010
I have created certain Macros. By customizing the ribbon ,i converted the Macros into buttons.
I saved the file as an add-in (.xlam). Now, when i send the file to other people, I shall tell them to copy the file to XLstart folder
When they open their excel,I want my custom ribbon(macro buttons) to appear in their excel.However, I am failing to do so. The macros book is transferred.However,the custom ribbons/buttons i created for macros, don't transfer.Is there any standard approach to do so.
I would really appreciate if could get some source for any standard approach or reference article for sharing custom local ribbons to other PCs.
microsoft-excel microsoft-excel-2010 macros
asked Aug 9 '14 at 15:56
Michel
12317
add a comment |
I have created certain Macros. By customizing the ribbon ,i converted the Macros into buttons.
I saved the file as an add-in (.xlam). Now, when i send the file to other people, I shall tell them to copy the file to XLstart folder
When they open their excel,I want my custom ribbon(macro buttons) to appear in their excel.However, I am failing to do so. The macros book is transferred.However,the custom ribbons/buttons i created for macros, don't transfer.Is there any standard approach to do so.
I would really appreciate if could get some source for any standard approach or reference article for sharing custom local ribbons to other PCs.
microsoft-excel microsoft-excel-2010 macros
asked Aug 9 '14 at 15:56
Michel
12317
add a comment |
I have created certain Macros. By customizing the ribbon ,i converted the Macros into buttons.
I saved the file as an add-in (.xlam). Now, when i send the file to other people, I shall tell them to copy the file to XLstart folder
When they open their excel,I want my custom ribbon(macro buttons) to appear in their excel.However, I am failing to do so. The macros book is transferred.However,the custom ribbons/buttons i created for macros, don't transfer.Is there any standard approach to do so.
I would really appreciate if could get some source for any standard approach or reference article for sharing custom local ribbons to other PCs.
microsoft-excel microsoft-excel-2010 macros
asked Aug 9 '14 at 15:56
Michel
12317
I have created certain Macros. By customizing the ribbon ,i converted the Macros into buttons.
I saved the file as an add-in (.xlam). Now, when i send the file to other people, I shall tell them to copy the file to XLstart folder
When they open their excel,I want my custom ribbon(macro buttons) to appear in their excel.However, I am failing to do so. The macros book is transferred.However,the custom ribbons/buttons i created for macros, don't transfer.Is there any standard approach to do so.
I would really appreciate if could get some source for any standard approach or reference article for sharing custom local ribbons to other PCs.
microsoft-excel microsoft-excel-2010 macros
microsoft-excel microsoft-excel-2010 macros
asked Aug 9 '14 at 15:56
Michel
12317
asked Aug 9 '14 at 15:56
Michel
12317
edited Aug 10 '14 at 19:02
asked Aug 9 '14 at 15:56
Michel
12317
asked Aug 9 '14 at 15:56
Michel
12317
asked Aug 9 '14 at 15:56
Michel
12317
12317
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Recommend that you simply go to the Developer tab and insert buttons on a Worksheet -- which DOES transfer from machine to machine and not worry about using the ribbon.
An additional advantage is that you have a lot more room to explain what the button does.
answered Jun 20 at 16:29
Carl
1
This would be a better answer if you described how to do this. Please do not respond in comments; edit your answer to make it clearer and more complete.
– G-Man
Jun 20 at 16:42
add a comment |
This is not an answer to your question but it will simplify it for you and others you send the file to.
You can make the file install itself.
Add a workbook open and in the sub I check if the there is a file with "filename.xlam" in the add-ins folder.
If not prompt with a msgbox and ask if they want to install.
Then use copy to copy the file from it's current location to the add-ins folder (you can't move it since you have the file open).
Once the file is copied to the add-ins folder you can "install it".
AddIns.Add("Add-in_name").Installed = True
To your actual question I may have an answer.
I have done it myself but the workbook I did it on is at work and I won't be at work until Monday.
If I remember (or if you remind me) I can have a look at it how I did in my file at work.
Edit: I just noticed this question was really old. It was at the top of my questions feed.
answered Aug 24 at 3:45
Andreas
13510
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f794679%2ftransferring-custom-excel-ribbons-in-local-computer-to-other-computers-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Recommend that you simply go to the Developer tab and insert buttons on a Worksheet -- which DOES transfer from machine to machine and not worry about using the ribbon.
An additional advantage is that you have a lot more room to explain what the button does.
answered Jun 20 at 16:29
Carl
1
This would be a better answer if you described how to do this. Please do not respond in comments; edit your answer to make it clearer and more complete.
– G-Man
Jun 20 at 16:42
add a comment |
Recommend that you simply go to the Developer tab and insert buttons on a Worksheet -- which DOES transfer from machine to machine and not worry about using the ribbon.
An additional advantage is that you have a lot more room to explain what the button does.
answered Jun 20 at 16:29
Carl
1
This would be a better answer if you described how to do this. Please do not respond in comments; edit your answer to make it clearer and more complete.
– G-Man
Jun 20 at 16:42
add a comment |
Recommend that you simply go to the Developer tab and insert buttons on a Worksheet -- which DOES transfer from machine to machine and not worry about using the ribbon.
An additional advantage is that you have a lot more room to explain what the button does.
answered Jun 20 at 16:29
Carl
1
Recommend that you simply go to the Developer tab and insert buttons on a Worksheet -- which DOES transfer from machine to machine and not worry about using the ribbon.
An additional advantage is that you have a lot more room to explain what the button does.
answered Jun 20 at 16:29
Carl
1
answered Jun 20 at 16:29
Carl
1
answered Jun 20 at 16:29
Carl
1
answered Jun 20 at 16:29
Carl
1
1
This would be a better answer if you described how to do this. Please do not respond in comments; edit your answer to make it clearer and more complete.
– G-Man
Jun 20 at 16:42
add a comment |
This would be a better answer if you described how to do this. Please do not respond in comments; edit your answer to make it clearer and more complete.
– G-Man
Jun 20 at 16:42
This would be a better answer if you described how to do this. Please do not respond in comments; edit your answer to make it clearer and more complete.
– G-Man
Jun 20 at 16:42
This would be a better answer if you described how to do this. Please do not respond in comments; edit your answer to make it clearer and more complete.
– G-Man
Jun 20 at 16:42
add a comment |
This is not an answer to your question but it will simplify it for you and others you send the file to.
You can make the file install itself.
Add a workbook open and in the sub I check if the there is a file with "filename.xlam" in the add-ins folder.
If not prompt with a msgbox and ask if they want to install.
Then use copy to copy the file from it's current location to the add-ins folder (you can't move it since you have the file open).
Once the file is copied to the add-ins folder you can "install it".
AddIns.Add("Add-in_name").Installed = True
To your actual question I may have an answer.
I have done it myself but the workbook I did it on is at work and I won't be at work until Monday.
If I remember (or if you remind me) I can have a look at it how I did in my file at work.
Edit: I just noticed this question was really old. It was at the top of my questions feed.
answered Aug 24 at 3:45
Andreas
13510
add a comment |
This is not an answer to your question but it will simplify it for you and others you send the file to.
You can make the file install itself.
Add a workbook open and in the sub I check if the there is a file with "filename.xlam" in the add-ins folder.
If not prompt with a msgbox and ask if they want to install.
Then use copy to copy the file from it's current location to the add-ins folder (you can't move it since you have the file open).
Once the file is copied to the add-ins folder you can "install it".
AddIns.Add("Add-in_name").Installed = True
To your actual question I may have an answer.
I have done it myself but the workbook I did it on is at work and I won't be at work until Monday.
If I remember (or if you remind me) I can have a look at it how I did in my file at work.
Edit: I just noticed this question was really old. It was at the top of my questions feed.
answered Aug 24 at 3:45
Andreas
13510
add a comment |
This is not an answer to your question but it will simplify it for you and others you send the file to.
You can make the file install itself.
Add a workbook open and in the sub I check if the there is a file with "filename.xlam" in the add-ins folder.
If not prompt with a msgbox and ask if they want to install.
Then use copy to copy the file from it's current location to the add-ins folder (you can't move it since you have the file open).
Once the file is copied to the add-ins folder you can "install it".
AddIns.Add("Add-in_name").Installed = True
To your actual question I may have an answer.
I have done it myself but the workbook I did it on is at work and I won't be at work until Monday.
If I remember (or if you remind me) I can have a look at it how I did in my file at work.
Edit: I just noticed this question was really old. It was at the top of my questions feed.
answered Aug 24 at 3:45
Andreas
13510
This is not an answer to your question but it will simplify it for you and others you send the file to.
You can make the file install itself.
Add a workbook open and in the sub I check if the there is a file with "filename.xlam" in the add-ins folder.
If not prompt with a msgbox and ask if they want to install.
Then use copy to copy the file from it's current location to the add-ins folder (you can't move it since you have the file open).
Once the file is copied to the add-ins folder you can "install it".
AddIns.Add("Add-in_name").Installed = True
To your actual question I may have an answer.
I have done it myself but the workbook I did it on is at work and I won't be at work until Monday.
If I remember (or if you remind me) I can have a look at it how I did in my file at work.
Edit: I just noticed this question was really old. It was at the top of my questions feed.
answered Aug 24 at 3:45
Andreas
13510
answered Aug 24 at 3:45
Andreas
13510
answered Aug 24 at 3:45
Andreas
13510
answered Aug 24 at 3:45
Andreas
13510
13510
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f794679%2ftransferring-custom-excel-ribbons-in-local-computer-to-other-computers-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
