non-English characters displayed incorrectly until CommandButton is clicked
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have excel file with some ActiveX CommandButtons integrated directly into worksheet. Their Captions written in non-English language with some non-English characters. Problem I encountered that some of these characters are not displayed correctly until CommandButton is clicked (picture below):
Have anybody encountered similar problem? I tried changing fonts and character size, but that did not helped.
I cannot provide any code since I have no idea where to start. Maybe it is possible to somehow fake constant focus to them?
excel vba excel-vba
asked Jan 4 at 13:20
GexasGexas
14710
add a comment |
I have excel file with some ActiveX CommandButtons integrated directly into worksheet. Their Captions written in non-English language with some non-English characters. Problem I encountered that some of these characters are not displayed correctly until CommandButton is clicked (picture below):
Have anybody encountered similar problem? I tried changing fonts and character size, but that did not helped.
I cannot provide any code since I have no idea where to start. Maybe it is possible to somehow fake constant focus to them?
excel vba excel-vba
asked Jan 4 at 13:20
GexasGexas
14710
add a comment |
I have excel file with some ActiveX CommandButtons integrated directly into worksheet. Their Captions written in non-English language with some non-English characters. Problem I encountered that some of these characters are not displayed correctly until CommandButton is clicked (picture below):
Have anybody encountered similar problem? I tried changing fonts and character size, but that did not helped.
I cannot provide any code since I have no idea where to start. Maybe it is possible to somehow fake constant focus to them?
excel vba excel-vba
asked Jan 4 at 13:20
GexasGexas
14710
I have excel file with some ActiveX CommandButtons integrated directly into worksheet. Their Captions written in non-English language with some non-English characters. Problem I encountered that some of these characters are not displayed correctly until CommandButton is clicked (picture below):
Have anybody encountered similar problem? I tried changing fonts and character size, but that did not helped.
I cannot provide any code since I have no idea where to start. Maybe it is possible to somehow fake constant focus to them?
excel vba excel-vba
excel vba excel-vba
asked Jan 4 at 13:20
GexasGexas
14710
asked Jan 4 at 13:20
GexasGexas
14710
asked Jan 4 at 13:20
GexasGexas
14710
asked Jan 4 at 13:20
GexasGexas
14710
asked Jan 4 at 13:20
GexasGexas
14710
14710
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Laba diena!
If you created these with ActiveX Command buttons, you should be able to view the name and caption properties by either 1) clicking once, then right-clicking to get a menu with properties as a choice or 2) double-clicking to get a click event started in the visual basic editor. From there you should see what's listed as the caption for the button.
In the button properties there should be a "TakeFocusOnClick" property that defaults to True. I don't know if it will fix your problem, but try changing it to false. I couldn't emulate your exact problem, so I couldn't tell.
sėkmės!
answered Jan 6 at 4:19
BrupieDBrupieD
585
Laba diena! Ačiū už atsakymą. Unfortunately, but that did not helped (but changing property to False removed doted line on click and gave cleaner look, upvote for that idea). While trying your suggestion I noticed, that if I go toProperties>Fontand change Script to Western and then to Baltic again letters are displayed correctly for whole session, but as soon as I close and reopen workbook, Baltic letters displayed incorrectly again. Now I am thinking if it is possible to write macro which on startup automatically change script to Western and Back to Baltic again.
– Gexas
Jan 7 at 6:15
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%2f54039741%2fnon-english-characters-displayed-incorrectly-until-commandbutton-is-clicked%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Laba diena!
If you created these with ActiveX Command buttons, you should be able to view the name and caption properties by either 1) clicking once, then right-clicking to get a menu with properties as a choice or 2) double-clicking to get a click event started in the visual basic editor. From there you should see what's listed as the caption for the button.
In the button properties there should be a "TakeFocusOnClick" property that defaults to True. I don't know if it will fix your problem, but try changing it to false. I couldn't emulate your exact problem, so I couldn't tell.
sėkmės!
answered Jan 6 at 4:19
BrupieDBrupieD
585
Laba diena! Ačiū už atsakymą. Unfortunately, but that did not helped (but changing property to False removed doted line on click and gave cleaner look, upvote for that idea). While trying your suggestion I noticed, that if I go toProperties>Fontand change Script to Western and then to Baltic again letters are displayed correctly for whole session, but as soon as I close and reopen workbook, Baltic letters displayed incorrectly again. Now I am thinking if it is possible to write macro which on startup automatically change script to Western and Back to Baltic again.
– Gexas
Jan 7 at 6:15
add a comment |
Laba diena!
If you created these with ActiveX Command buttons, you should be able to view the name and caption properties by either 1) clicking once, then right-clicking to get a menu with properties as a choice or 2) double-clicking to get a click event started in the visual basic editor. From there you should see what's listed as the caption for the button.
In the button properties there should be a "TakeFocusOnClick" property that defaults to True. I don't know if it will fix your problem, but try changing it to false. I couldn't emulate your exact problem, so I couldn't tell.
sėkmės!
answered Jan 6 at 4:19
BrupieDBrupieD
585
Laba diena! Ačiū už atsakymą. Unfortunately, but that did not helped (but changing property to False removed doted line on click and gave cleaner look, upvote for that idea). While trying your suggestion I noticed, that if I go toProperties>Fontand change Script to Western and then to Baltic again letters are displayed correctly for whole session, but as soon as I close and reopen workbook, Baltic letters displayed incorrectly again. Now I am thinking if it is possible to write macro which on startup automatically change script to Western and Back to Baltic again.
– Gexas
Jan 7 at 6:15
add a comment |
Laba diena!
If you created these with ActiveX Command buttons, you should be able to view the name and caption properties by either 1) clicking once, then right-clicking to get a menu with properties as a choice or 2) double-clicking to get a click event started in the visual basic editor. From there you should see what's listed as the caption for the button.
In the button properties there should be a "TakeFocusOnClick" property that defaults to True. I don't know if it will fix your problem, but try changing it to false. I couldn't emulate your exact problem, so I couldn't tell.
sėkmės!
answered Jan 6 at 4:19
BrupieDBrupieD
585
Laba diena!
If you created these with ActiveX Command buttons, you should be able to view the name and caption properties by either 1) clicking once, then right-clicking to get a menu with properties as a choice or 2) double-clicking to get a click event started in the visual basic editor. From there you should see what's listed as the caption for the button.
In the button properties there should be a "TakeFocusOnClick" property that defaults to True. I don't know if it will fix your problem, but try changing it to false. I couldn't emulate your exact problem, so I couldn't tell.
sėkmės!
answered Jan 6 at 4:19
BrupieDBrupieD
585
answered Jan 6 at 4:19
BrupieDBrupieD
585
answered Jan 6 at 4:19
BrupieDBrupieD
585
answered Jan 6 at 4:19
BrupieDBrupieD
585
585
Laba diena! Ačiū už atsakymą. Unfortunately, but that did not helped (but changing property to False removed doted line on click and gave cleaner look, upvote for that idea). While trying your suggestion I noticed, that if I go toProperties>Fontand change Script to Western and then to Baltic again letters are displayed correctly for whole session, but as soon as I close and reopen workbook, Baltic letters displayed incorrectly again. Now I am thinking if it is possible to write macro which on startup automatically change script to Western and Back to Baltic again.
– Gexas
Jan 7 at 6:15
add a comment |
Laba diena! Ačiū už atsakymą. Unfortunately, but that did not helped (but changing property to False removed doted line on click and gave cleaner look, upvote for that idea). While trying your suggestion I noticed, that if I go toProperties>Fontand change Script to Western and then to Baltic again letters are displayed correctly for whole session, but as soon as I close and reopen workbook, Baltic letters displayed incorrectly again. Now I am thinking if it is possible to write macro which on startup automatically change script to Western and Back to Baltic again.
– Gexas
Jan 7 at 6:15
Laba diena! Ačiū už atsakymą. Unfortunately, but that did not helped (but changing property to False removed doted line on click and gave cleaner look, upvote for that idea). While trying your suggestion I noticed, that if I go to
Properties>Font and change Script to Western and then to Baltic again letters are displayed correctly for whole session, but as soon as I close and reopen workbook, Baltic letters displayed incorrectly again. Now I am thinking if it is possible to write macro which on startup automatically change script to Western and Back to Baltic again.– Gexas
Jan 7 at 6:15
Laba diena! Ačiū už atsakymą. Unfortunately, but that did not helped (but changing property to False removed doted line on click and gave cleaner look, upvote for that idea). While trying your suggestion I noticed, that if I go to
Properties>Font and change Script to Western and then to Baltic again letters are displayed correctly for whole session, but as soon as I close and reopen workbook, Baltic letters displayed incorrectly again. Now I am thinking if it is possible to write macro which on startup automatically change script to Western and Back to Baltic again.– Gexas
Jan 7 at 6:15
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%2f54039741%2fnon-english-characters-displayed-incorrectly-until-commandbutton-is-clicked%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
