How to transfer EXCEL macro shortcut for the same user on different office PCs
I have a problem that I quite frequently have to change PC on my work but I always keep my user settings on local drive. Every time I change the PC I have the EXCEL settings reseted and all the imported macroses removed from panel.
Is there a way to store EXCEL settings and macros buttons so when I change PC they do not disappear.
Thank you!
windows microsoft-excel microsoft-office macros local
asked Jan 11 at 9:13
Vladislav KolontaiVladislav Kolontai
11
add a comment |
I have a problem that I quite frequently have to change PC on my work but I always keep my user settings on local drive. Every time I change the PC I have the EXCEL settings reseted and all the imported macroses removed from panel.
Is there a way to store EXCEL settings and macros buttons so when I change PC they do not disappear.
Thank you!
windows microsoft-excel microsoft-office macros local
asked Jan 11 at 9:13
Vladislav KolontaiVladislav Kolontai
11
Are you able to use/run files off a USB drive in your work environment? If so, you could potentially save a blank excel file with macros in modules. Then, open that file on any PC and open specific Excel files through File>Open (instead of opening files directly). That way, the modules will still be applied to any workbook opened. I know this at least works in 2010.
– jrichall
Jan 11 at 16:22
add a comment |
I have a problem that I quite frequently have to change PC on my work but I always keep my user settings on local drive. Every time I change the PC I have the EXCEL settings reseted and all the imported macroses removed from panel.
Is there a way to store EXCEL settings and macros buttons so when I change PC they do not disappear.
Thank you!
windows microsoft-excel microsoft-office macros local
asked Jan 11 at 9:13
Vladislav KolontaiVladislav Kolontai
11
I have a problem that I quite frequently have to change PC on my work but I always keep my user settings on local drive. Every time I change the PC I have the EXCEL settings reseted and all the imported macroses removed from panel.
Is there a way to store EXCEL settings and macros buttons so when I change PC they do not disappear.
Thank you!
windows microsoft-excel microsoft-office macros local
windows microsoft-excel microsoft-office macros local
asked Jan 11 at 9:13
Vladislav KolontaiVladislav Kolontai
11
asked Jan 11 at 9:13
Vladislav KolontaiVladislav Kolontai
11
edited Jan 11 at 9:38
Vladislav Kolontai
asked Jan 11 at 9:13
Vladislav KolontaiVladislav Kolontai
11
asked Jan 11 at 9:13
Vladislav KolontaiVladislav Kolontai
11
asked Jan 11 at 9:13
Vladislav KolontaiVladislav Kolontai
11
11
Are you able to use/run files off a USB drive in your work environment? If so, you could potentially save a blank excel file with macros in modules. Then, open that file on any PC and open specific Excel files through File>Open (instead of opening files directly). That way, the modules will still be applied to any workbook opened. I know this at least works in 2010.
– jrichall
Jan 11 at 16:22
add a comment |
Are you able to use/run files off a USB drive in your work environment? If so, you could potentially save a blank excel file with macros in modules. Then, open that file on any PC and open specific Excel files through File>Open (instead of opening files directly). That way, the modules will still be applied to any workbook opened. I know this at least works in 2010.
– jrichall
Jan 11 at 16:22
Are you able to use/run files off a USB drive in your work environment? If so, you could potentially save a blank excel file with macros in modules. Then, open that file on any PC and open specific Excel files through File>Open (instead of opening files directly). That way, the modules will still be applied to any workbook opened. I know this at least works in 2010.
– jrichall
Jan 11 at 16:22
Are you able to use/run files off a USB drive in your work environment? If so, you could potentially save a blank excel file with macros in modules. Then, open that file on any PC and open specific Excel files through File>Open (instead of opening files directly). That way, the modules will still be applied to any workbook opened. I know this at least works in 2010.
– jrichall
Jan 11 at 16:22
add a comment |
0
active
oldest
votes
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%2f1393086%2fhow-to-transfer-excel-macro-shortcut-for-the-same-user-on-different-office-pcs%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f1393086%2fhow-to-transfer-excel-macro-shortcut-for-the-same-user-on-different-office-pcs%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
Are you able to use/run files off a USB drive in your work environment? If so, you could potentially save a blank excel file with macros in modules. Then, open that file on any PC and open specific Excel files through File>Open (instead of opening files directly). That way, the modules will still be applied to any workbook opened. I know this at least works in 2010.
– jrichall
Jan 11 at 16:22