VBA and printing Excel workbook
0
Good morning,
how can I intercept, in the "Workbook_BeforePrint" event, the printing choice made by the user (the whole folder, active sheets, current selection). I would, for example, to inhibit the printing of a specific sheet (eg: Sheet2) if the user has chosen to print the entire folder.
Thank you very much
Ivo
excel vba excel-vba printing
edited Nov 24 '18 at 16:35
BigBen
5,9142418
asked Nov 24 '18 at 13:59
gianivogianivo
1
add a comment |
0
Good morning,
how can I intercept, in the "Workbook_BeforePrint" event, the printing choice made by the user (the whole folder, active sheets, current selection). I would, for example, to inhibit the printing of a specific sheet (eg: Sheet2) if the user has chosen to print the entire folder.
Thank you very much
Ivo
excel vba excel-vba printing
edited Nov 24 '18 at 16:35
BigBen
5,9142418
asked Nov 24 '18 at 13:59
gianivogianivo
1
Can you post your code, what have you tried so far?
– Ole EH Dufour
Nov 24 '18 at 14:01
stackoverflow.com/help/mcve
– peakpeak
Nov 24 '18 at 17:19
Goto the link and read the paragraph titled Prevent Printing Of A Specific Worksheet
– GMalc
Nov 24 '18 at 18:47
add a comment |
0
0
0
Good morning,
how can I intercept, in the "Workbook_BeforePrint" event, the printing choice made by the user (the whole folder, active sheets, current selection). I would, for example, to inhibit the printing of a specific sheet (eg: Sheet2) if the user has chosen to print the entire folder.
Thank you very much
Ivo
excel vba excel-vba printing
edited Nov 24 '18 at 16:35
BigBen
5,9142418
asked Nov 24 '18 at 13:59
gianivogianivo
1
Good morning,
how can I intercept, in the "Workbook_BeforePrint" event, the printing choice made by the user (the whole folder, active sheets, current selection). I would, for example, to inhibit the printing of a specific sheet (eg: Sheet2) if the user has chosen to print the entire folder.
Thank you very much
Ivo
excel vba excel-vba printing
excel vba excel-vba printing
edited Nov 24 '18 at 16:35
BigBen
5,9142418
asked Nov 24 '18 at 13:59
gianivogianivo
1
edited Nov 24 '18 at 16:35
BigBen
5,9142418
asked Nov 24 '18 at 13:59
gianivogianivo
1
edited Nov 24 '18 at 16:35
BigBen
5,9142418
edited Nov 24 '18 at 16:35
BigBen
5,9142418
edited Nov 24 '18 at 16:35
BigBen
5,9142418
5,9142418
asked Nov 24 '18 at 13:59
gianivogianivo
1
asked Nov 24 '18 at 13:59
gianivogianivo
1
asked Nov 24 '18 at 13:59
gianivogianivo
1
1
Can you post your code, what have you tried so far?
– Ole EH Dufour
Nov 24 '18 at 14:01
stackoverflow.com/help/mcve
– peakpeak
Nov 24 '18 at 17:19
Goto the link and read the paragraph titled Prevent Printing Of A Specific Worksheet
– GMalc
Nov 24 '18 at 18:47
add a comment |
Can you post your code, what have you tried so far?
– Ole EH Dufour
Nov 24 '18 at 14:01
stackoverflow.com/help/mcve
– peakpeak
Nov 24 '18 at 17:19
Goto the link and read the paragraph titled Prevent Printing Of A Specific Worksheet
– GMalc
Nov 24 '18 at 18:47
Can you post your code, what have you tried so far?
– Ole EH Dufour
Nov 24 '18 at 14:01
Can you post your code, what have you tried so far?
– Ole EH Dufour
Nov 24 '18 at 14:01
stackoverflow.com/help/mcve
– peakpeak
Nov 24 '18 at 17:19
stackoverflow.com/help/mcve
– peakpeak
Nov 24 '18 at 17:19
Goto the link and read the paragraph titled Prevent Printing Of A Specific Worksheet
– GMalc
Nov 24 '18 at 18:47
Goto the link and read the paragraph titled Prevent Printing Of A Specific Worksheet
– GMalc
Nov 24 '18 at 18:47
add a comment |
1 Answer
1
active
oldest
votes
0
Evaluate each worksheet in the loop and decide what to do.
Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
Debug.Print ws.name 'Do we want to print this?
Next
End Sub
answered Nov 24 '18 at 17:34
peakpeakpeakpeak
630312
Thank you very much, I know this method. But my question is a bit different: can I know from VBA if the user has chosen to print the whole workbook, only the active folders or the current selection? There is a method for this (e.g: ThisWorkbook.SelectionType ? or something similar)?
– gianivo
Nov 25 '18 at 17:23
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
});
}
});
draft saved
draft discarded
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%2f53458897%2fvba-and-printing-excel-workbook%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
0
Evaluate each worksheet in the loop and decide what to do.
Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
Debug.Print ws.name 'Do we want to print this?
Next
End Sub
answered Nov 24 '18 at 17:34
peakpeakpeakpeak
630312
Thank you very much, I know this method. But my question is a bit different: can I know from VBA if the user has chosen to print the whole workbook, only the active folders or the current selection? There is a method for this (e.g: ThisWorkbook.SelectionType ? or something similar)?
– gianivo
Nov 25 '18 at 17:23
add a comment |
0
Evaluate each worksheet in the loop and decide what to do.
Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
Debug.Print ws.name 'Do we want to print this?
Next
End Sub
answered Nov 24 '18 at 17:34
peakpeakpeakpeak
630312
Thank you very much, I know this method. But my question is a bit different: can I know from VBA if the user has chosen to print the whole workbook, only the active folders or the current selection? There is a method for this (e.g: ThisWorkbook.SelectionType ? or something similar)?
– gianivo
Nov 25 '18 at 17:23
add a comment |
0
0
0
Evaluate each worksheet in the loop and decide what to do.
Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
Debug.Print ws.name 'Do we want to print this?
Next
End Sub
answered Nov 24 '18 at 17:34
peakpeakpeakpeak
630312
Evaluate each worksheet in the loop and decide what to do.
Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
Debug.Print ws.name 'Do we want to print this?
Next
End Sub
answered Nov 24 '18 at 17:34
peakpeakpeakpeak
630312
answered Nov 24 '18 at 17:34
peakpeakpeakpeak
630312
answered Nov 24 '18 at 17:34
peakpeakpeakpeak
630312
answered Nov 24 '18 at 17:34
peakpeakpeakpeak
630312
630312
Thank you very much, I know this method. But my question is a bit different: can I know from VBA if the user has chosen to print the whole workbook, only the active folders or the current selection? There is a method for this (e.g: ThisWorkbook.SelectionType ? or something similar)?
– gianivo
Nov 25 '18 at 17:23
add a comment |
Thank you very much, I know this method. But my question is a bit different: can I know from VBA if the user has chosen to print the whole workbook, only the active folders or the current selection? There is a method for this (e.g: ThisWorkbook.SelectionType ? or something similar)?
– gianivo
Nov 25 '18 at 17:23
Thank you very much, I know this method. But my question is a bit different: can I know from VBA if the user has chosen to print the whole workbook, only the active folders or the current selection? There is a method for this (e.g: ThisWorkbook.SelectionType ? or something similar)?
– gianivo
Nov 25 '18 at 17:23
Thank you very much, I know this method. But my question is a bit different: can I know from VBA if the user has chosen to print the whole workbook, only the active folders or the current selection? There is a method for this (e.g: ThisWorkbook.SelectionType ? or something similar)?
– gianivo
Nov 25 '18 at 17:23
add a comment |
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53458897%2fvba-and-printing-excel-workbook%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
Can you post your code, what have you tried so far?
– Ole EH Dufour
Nov 24 '18 at 14:01
stackoverflow.com/help/mcve
– peakpeak
Nov 24 '18 at 17:19
Goto the link and read the paragraph titled Prevent Printing Of A Specific Worksheet
– GMalc
Nov 24 '18 at 18:47