Mixing
Excel editing command button name not changing
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
When I am editing command button and I go to the top left corner to change the name of the command button it allows me to edit the text and change it but when I press enter or click somewhere the name of the button keeps reverting back to the original name.
I've tried also tried making sure design mode is selected as well, and the command button and the sheet do not have any protection on either
I'm sure I'm missing something simple.
excel vba
asked Oct 31 '14 at 11:30
WindmillWindmill
88217
add a comment |
When I am editing command button and I go to the top left corner to change the name of the command button it allows me to edit the text and change it but when I press enter or click somewhere the name of the button keeps reverting back to the original name.
I've tried also tried making sure design mode is selected as well, and the command button and the sheet do not have any protection on either
I'm sure I'm missing something simple.
excel vba
asked Oct 31 '14 at 11:30
WindmillWindmill
88217
have you checked that you don't already have a button with the name your are trying to change it to? Try a different name and see if that works.
– user2140173
Oct 31 '14 at 11:31
What name are you trying to give exactly?
– Matteo NNZ
Oct 31 '14 at 11:32
thanks vba4all it wasnt that I had another button with that name on my sheet it was that at some point I had had a button with that name and I needed to delete it from my module inorder to allow me to use it again, I wouldnt have thought of looking for that if you hadnt have mention about another button with the same name
– Windmill
Oct 31 '14 at 11:44
add a comment |
When I am editing command button and I go to the top left corner to change the name of the command button it allows me to edit the text and change it but when I press enter or click somewhere the name of the button keeps reverting back to the original name.
I've tried also tried making sure design mode is selected as well, and the command button and the sheet do not have any protection on either
I'm sure I'm missing something simple.
excel vba
asked Oct 31 '14 at 11:30
WindmillWindmill
88217
When I am editing command button and I go to the top left corner to change the name of the command button it allows me to edit the text and change it but when I press enter or click somewhere the name of the button keeps reverting back to the original name.
I've tried also tried making sure design mode is selected as well, and the command button and the sheet do not have any protection on either
I'm sure I'm missing something simple.
excel vba
excel vba
asked Oct 31 '14 at 11:30
WindmillWindmill
88217
asked Oct 31 '14 at 11:30
WindmillWindmill
88217
asked Oct 31 '14 at 11:30
WindmillWindmill
88217
asked Oct 31 '14 at 11:30
WindmillWindmill
88217
asked Oct 31 '14 at 11:30
WindmillWindmill
88217
88217
have you checked that you don't already have a button with the name your are trying to change it to? Try a different name and see if that works.
– user2140173
Oct 31 '14 at 11:31
What name are you trying to give exactly?
– Matteo NNZ
Oct 31 '14 at 11:32
thanks vba4all it wasnt that I had another button with that name on my sheet it was that at some point I had had a button with that name and I needed to delete it from my module inorder to allow me to use it again, I wouldnt have thought of looking for that if you hadnt have mention about another button with the same name
– Windmill
Oct 31 '14 at 11:44
add a comment |
have you checked that you don't already have a button with the name your are trying to change it to? Try a different name and see if that works.
– user2140173
Oct 31 '14 at 11:31
What name are you trying to give exactly?
– Matteo NNZ
Oct 31 '14 at 11:32
thanks vba4all it wasnt that I had another button with that name on my sheet it was that at some point I had had a button with that name and I needed to delete it from my module inorder to allow me to use it again, I wouldnt have thought of looking for that if you hadnt have mention about another button with the same name
– Windmill
Oct 31 '14 at 11:44
have you checked that you don't already have a button with the name your are trying to change it to? Try a different name and see if that works.
– user2140173
Oct 31 '14 at 11:31
have you checked that you don't already have a button with the name your are trying to change it to? Try a different name and see if that works.
– user2140173
Oct 31 '14 at 11:31
What name are you trying to give exactly?
– Matteo NNZ
Oct 31 '14 at 11:32
What name are you trying to give exactly?
– Matteo NNZ
Oct 31 '14 at 11:32
thanks vba4all it wasnt that I had another button with that name on my sheet it was that at some point I had had a button with that name and I needed to delete it from my module inorder to allow me to use it again, I wouldnt have thought of looking for that if you hadnt have mention about another button with the same name
– Windmill
Oct 31 '14 at 11:44
thanks vba4all it wasnt that I had another button with that name on my sheet it was that at some point I had had a button with that name and I needed to delete it from my module inorder to allow me to use it again, I wouldnt have thought of looking for that if you hadnt have mention about another button with the same name
– Windmill
Oct 31 '14 at 11:44
add a comment |
2 Answers
2
active
oldest
votes
I had a very similar problem. Solved! My problem was that I would create an ACTIVEX button, and using the properties, give it a customized name (changing CommandButton1 to something much more descriptive)... then later, upon saving and re-opening the excel, some of these buttons (not all) would revert to CommandButtonX.
The whole problem was THE LENGTH OF THE NAME. My names that failed would be around 39 chars or more (somewhere around 39). Using the selection objects pane under the Excel "Find and Select" menu item, I observed the ones that would fail vs succeed.... comparing what I would change in that pane with control properties (Name) and the excel "sheet Name Box" in the upper left area of the sheet screen.
answered Sep 10 '16 at 14:26
Sandy418Sandy418
1
add a comment |
When we have to rename the command button, you can use properties and namebox. But the purpose to change the appearance of button, you have to go to
properties->caption. In caption, you can rename button's appearance.
answered Jan 3 at 5:05
MurMur
12
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f26673677%2fexcel-editing-command-button-name-not-changing%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
I had a very similar problem. Solved! My problem was that I would create an ACTIVEX button, and using the properties, give it a customized name (changing CommandButton1 to something much more descriptive)... then later, upon saving and re-opening the excel, some of these buttons (not all) would revert to CommandButtonX.
The whole problem was THE LENGTH OF THE NAME. My names that failed would be around 39 chars or more (somewhere around 39). Using the selection objects pane under the Excel "Find and Select" menu item, I observed the ones that would fail vs succeed.... comparing what I would change in that pane with control properties (Name) and the excel "sheet Name Box" in the upper left area of the sheet screen.
answered Sep 10 '16 at 14:26
Sandy418Sandy418
1
add a comment |
I had a very similar problem. Solved! My problem was that I would create an ACTIVEX button, and using the properties, give it a customized name (changing CommandButton1 to something much more descriptive)... then later, upon saving and re-opening the excel, some of these buttons (not all) would revert to CommandButtonX.
The whole problem was THE LENGTH OF THE NAME. My names that failed would be around 39 chars or more (somewhere around 39). Using the selection objects pane under the Excel "Find and Select" menu item, I observed the ones that would fail vs succeed.... comparing what I would change in that pane with control properties (Name) and the excel "sheet Name Box" in the upper left area of the sheet screen.
answered Sep 10 '16 at 14:26
Sandy418Sandy418
1
add a comment |
I had a very similar problem. Solved! My problem was that I would create an ACTIVEX button, and using the properties, give it a customized name (changing CommandButton1 to something much more descriptive)... then later, upon saving and re-opening the excel, some of these buttons (not all) would revert to CommandButtonX.
The whole problem was THE LENGTH OF THE NAME. My names that failed would be around 39 chars or more (somewhere around 39). Using the selection objects pane under the Excel "Find and Select" menu item, I observed the ones that would fail vs succeed.... comparing what I would change in that pane with control properties (Name) and the excel "sheet Name Box" in the upper left area of the sheet screen.
answered Sep 10 '16 at 14:26
Sandy418Sandy418
1
I had a very similar problem. Solved! My problem was that I would create an ACTIVEX button, and using the properties, give it a customized name (changing CommandButton1 to something much more descriptive)... then later, upon saving and re-opening the excel, some of these buttons (not all) would revert to CommandButtonX.
The whole problem was THE LENGTH OF THE NAME. My names that failed would be around 39 chars or more (somewhere around 39). Using the selection objects pane under the Excel "Find and Select" menu item, I observed the ones that would fail vs succeed.... comparing what I would change in that pane with control properties (Name) and the excel "sheet Name Box" in the upper left area of the sheet screen.
answered Sep 10 '16 at 14:26
Sandy418Sandy418
1
answered Sep 10 '16 at 14:26
Sandy418Sandy418
1
answered Sep 10 '16 at 14:26
Sandy418Sandy418
1
answered Sep 10 '16 at 14:26
Sandy418Sandy418
1
1
add a comment |
add a comment |
When we have to rename the command button, you can use properties and namebox. But the purpose to change the appearance of button, you have to go to
properties->caption. In caption, you can rename button's appearance.
answered Jan 3 at 5:05
MurMur
12
add a comment |
When we have to rename the command button, you can use properties and namebox. But the purpose to change the appearance of button, you have to go to
properties->caption. In caption, you can rename button's appearance.
answered Jan 3 at 5:05
MurMur
12
add a comment |
When we have to rename the command button, you can use properties and namebox. But the purpose to change the appearance of button, you have to go to
properties->caption. In caption, you can rename button's appearance.
answered Jan 3 at 5:05
MurMur
12
When we have to rename the command button, you can use properties and namebox. But the purpose to change the appearance of button, you have to go to
properties->caption. In caption, you can rename button's appearance.
answered Jan 3 at 5:05
MurMur
12
answered Jan 3 at 5:05
MurMur
12
answered Jan 3 at 5:05
MurMur
12
answered Jan 3 at 5:05
MurMur
12
12
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f26673677%2fexcel-editing-command-button-name-not-changing%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
have you checked that you don't already have a button with the name your are trying to change it to? Try a different name and see if that works.
– user2140173
Oct 31 '14 at 11:31
What name are you trying to give exactly?
– Matteo NNZ
Oct 31 '14 at 11:32
thanks vba4all it wasnt that I had another button with that name on my sheet it was that at some point I had had a button with that name and I needed to delete it from my module inorder to allow me to use it again, I wouldnt have thought of looking for that if you hadnt have mention about another button with the same name
– Windmill
Oct 31 '14 at 11:44