Column width not changing for shared workbooks
So I have this bit of code set to automatically add a new column everyday at a certain time. This macro I set to only apply to one user so there won't be duplicate column created.
If Environ("Username") = genericUser Then
If Range("G11").Value <> Date Then
Range("G1").EntireColumn.Insert
Range("G11").Select
ActiveCell.FormulaR1C1 = LDate
Range("G12").ColumnWidth = 70
Range("G12").Select
End If
End If
The thing is for any user other than genericUser, the column will show as 14 instead of 70. I fixed this by adding a check (for all users) but I was curious to know if this is an issue with shared workbooks in general or if it's something that can be fixed by altering the macro above.
Note, the fix I mentioned. I included this on workbook open and on auto updates:
If Range("G12").ColumnWidth <> 70 Then
Range("G12").ColumnWidth = 70
End If
excel vba excel-vba
asked Nov 19 '18 at 13:02
b.sauerb.sauer
526
add a comment |
So I have this bit of code set to automatically add a new column everyday at a certain time. This macro I set to only apply to one user so there won't be duplicate column created.
If Environ("Username") = genericUser Then
If Range("G11").Value <> Date Then
Range("G1").EntireColumn.Insert
Range("G11").Select
ActiveCell.FormulaR1C1 = LDate
Range("G12").ColumnWidth = 70
Range("G12").Select
End If
End If
The thing is for any user other than genericUser, the column will show as 14 instead of 70. I fixed this by adding a check (for all users) but I was curious to know if this is an issue with shared workbooks in general or if it's something that can be fixed by altering the macro above.
Note, the fix I mentioned. I included this on workbook open and on auto updates:
If Range("G12").ColumnWidth <> 70 Then
Range("G12").ColumnWidth = 70
End If
excel vba excel-vba
asked Nov 19 '18 at 13:02
b.sauerb.sauer
526
add a comment |
So I have this bit of code set to automatically add a new column everyday at a certain time. This macro I set to only apply to one user so there won't be duplicate column created.
If Environ("Username") = genericUser Then
If Range("G11").Value <> Date Then
Range("G1").EntireColumn.Insert
Range("G11").Select
ActiveCell.FormulaR1C1 = LDate
Range("G12").ColumnWidth = 70
Range("G12").Select
End If
End If
The thing is for any user other than genericUser, the column will show as 14 instead of 70. I fixed this by adding a check (for all users) but I was curious to know if this is an issue with shared workbooks in general or if it's something that can be fixed by altering the macro above.
Note, the fix I mentioned. I included this on workbook open and on auto updates:
If Range("G12").ColumnWidth <> 70 Then
Range("G12").ColumnWidth = 70
End If
excel vba excel-vba
asked Nov 19 '18 at 13:02
b.sauerb.sauer
526
So I have this bit of code set to automatically add a new column everyday at a certain time. This macro I set to only apply to one user so there won't be duplicate column created.
If Environ("Username") = genericUser Then
If Range("G11").Value <> Date Then
Range("G1").EntireColumn.Insert
Range("G11").Select
ActiveCell.FormulaR1C1 = LDate
Range("G12").ColumnWidth = 70
Range("G12").Select
End If
End If
The thing is for any user other than genericUser, the column will show as 14 instead of 70. I fixed this by adding a check (for all users) but I was curious to know if this is an issue with shared workbooks in general or if it's something that can be fixed by altering the macro above.
Note, the fix I mentioned. I included this on workbook open and on auto updates:
If Range("G12").ColumnWidth <> 70 Then
Range("G12").ColumnWidth = 70
End If
excel vba excel-vba
excel vba excel-vba
asked Nov 19 '18 at 13:02
b.sauerb.sauer
526
asked Nov 19 '18 at 13:02
b.sauerb.sauer
526
asked Nov 19 '18 at 13:02
b.sauerb.sauer
526
asked Nov 19 '18 at 13:02
b.sauerb.sauer
526
asked Nov 19 '18 at 13:02
b.sauerb.sauer
526
526
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Did you try to include worksheet for any user other than genericUser?
I think it's needed if you have more than one sheets.
If Worksheets("NameOfWorksheet).Range("G12").ColumnWidth <> 70 Then
Worksheets("NameOfWorksheet).Range("G12").ColumnWidth = 70
End If
Hope this help.
answered Nov 19 '18 at 13:31
adhy wijayaadhy wijaya
43817
There's only one sheet in the workbook.
– b.sauer
Nov 19 '18 at 13:40
OK, I think it should be updated after the genericUser save the workbook
– adhy wijaya
Nov 19 '18 at 15:20
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%2f53375267%2fcolumn-width-not-changing-for-shared-workbooks%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
Did you try to include worksheet for any user other than genericUser?
I think it's needed if you have more than one sheets.
If Worksheets("NameOfWorksheet).Range("G12").ColumnWidth <> 70 Then
Worksheets("NameOfWorksheet).Range("G12").ColumnWidth = 70
End If
Hope this help.
answered Nov 19 '18 at 13:31
adhy wijayaadhy wijaya
43817
There's only one sheet in the workbook.
– b.sauer
Nov 19 '18 at 13:40
OK, I think it should be updated after the genericUser save the workbook
– adhy wijaya
Nov 19 '18 at 15:20
add a comment |
Did you try to include worksheet for any user other than genericUser?
I think it's needed if you have more than one sheets.
If Worksheets("NameOfWorksheet).Range("G12").ColumnWidth <> 70 Then
Worksheets("NameOfWorksheet).Range("G12").ColumnWidth = 70
End If
Hope this help.
answered Nov 19 '18 at 13:31
adhy wijayaadhy wijaya
43817
There's only one sheet in the workbook.
– b.sauer
Nov 19 '18 at 13:40
OK, I think it should be updated after the genericUser save the workbook
– adhy wijaya
Nov 19 '18 at 15:20
add a comment |
Did you try to include worksheet for any user other than genericUser?
I think it's needed if you have more than one sheets.
If Worksheets("NameOfWorksheet).Range("G12").ColumnWidth <> 70 Then
Worksheets("NameOfWorksheet).Range("G12").ColumnWidth = 70
End If
Hope this help.
answered Nov 19 '18 at 13:31
adhy wijayaadhy wijaya
43817
Did you try to include worksheet for any user other than genericUser?
I think it's needed if you have more than one sheets.
If Worksheets("NameOfWorksheet).Range("G12").ColumnWidth <> 70 Then
Worksheets("NameOfWorksheet).Range("G12").ColumnWidth = 70
End If
Hope this help.
answered Nov 19 '18 at 13:31
adhy wijayaadhy wijaya
43817
answered Nov 19 '18 at 13:31
adhy wijayaadhy wijaya
43817
answered Nov 19 '18 at 13:31
adhy wijayaadhy wijaya
43817
answered Nov 19 '18 at 13:31
adhy wijayaadhy wijaya
43817
43817
There's only one sheet in the workbook.
– b.sauer
Nov 19 '18 at 13:40
OK, I think it should be updated after the genericUser save the workbook
– adhy wijaya
Nov 19 '18 at 15:20
add a comment |
There's only one sheet in the workbook.
– b.sauer
Nov 19 '18 at 13:40
OK, I think it should be updated after the genericUser save the workbook
– adhy wijaya
Nov 19 '18 at 15:20
There's only one sheet in the workbook.
– b.sauer
Nov 19 '18 at 13:40
There's only one sheet in the workbook.
– b.sauer
Nov 19 '18 at 13:40
OK, I think it should be updated after the genericUser save the workbook
– adhy wijaya
Nov 19 '18 at 15:20
OK, I think it should be updated after the genericUser save the workbook
– adhy wijaya
Nov 19 '18 at 15:20
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%2f53375267%2fcolumn-width-not-changing-for-shared-workbooks%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
