I have a number of worksheets in my workbook, but one contains information that is only relevant when using a computer. How do I make it so it does not get printed when the WB does? I don't want to hide the WS.
I am looking for something like
But I don't want to end the entire print, just not have the print capture that worksheet.
Please Login or Register to view this content.
Last edited by bcas77; 07-22-2013 at 10:38 AM.
Hello bcas77,
Could you be a bit more explicit please. Which Page or Sheet do you not want to be printed?
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
The Worksheet that I do not want printed is called HotKey Codes. It contains a list of all the Hotkeys I have assigned Macros to.
Hello bcas77,
Then please try it like this:
Sample WorkBook attached.Please Login or Register to view this content.
Also see the "Please consider" note at the bottom of this post.
Thanks! That should work
Is there a way to do it via the normal print process though? The people who will be using it in the future may or may not know how to run macros, so I am hoping it'll be able to run in the background for them.
No. It cannot be done without VBA.Is there a way to do it via the normal print process though?
No, sorry I should've clarified. I meant is there any way to do it if I press ctrl + P or click the print button too? I'll be able to use it well, but a person who just wants to print it off will not think to check the macros before printing. Is there any macro I can make that will disallow printing of that one?
One way I was thinking was if they hit print, make the hotkey codes sheet go invisible, and then after printing is completed have it be visible again? Can that work?
you could experiment with the Wordbook_BeforePring() event. Try this, seems to work on my end
Please Login or Register to view this content.
Last edited by GeneralDisarray; 07-24-2013 at 10:04 AM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
That works.... but why??? I see no reference to the HotKey Codes in it...?
Well, long story short, Excel gives you the ability to control what happens on certain "workbook events". When you print, there is a workbook event called BeforePrint that can be accessed in the code. Think of the event as something that happens whenever the action of printing is called upon - no matter how that action is initiated.
If you add code to the BeforePrint event, that code will happen whether the user goes to File>Print or presses Cntrl+P. The Cancel=TRUE stops the users action from being handled in the normal excel way. Basically, by using Winon's code, you have handled how you want the workbook printed and you tell excel "cancel that command from the user please".
Also, turning off events with "application.enableEvents = false" is important! Otherwise when Winon's macro executes the event will fire over and over....
It appears in the module of the Workbook as provided in Post # 4.I see no reference to the HotKey Codes in it...?
Sorry Winon, just jumped in here :D I think the OP was wondering with the macro was able to work when the user pressed Cntrl+P.
All I did was ask the workbook_BeforePrint() event to launch your macro.
Please Login or Register to view this content.
Hello GeneralDisarray,
No problem, you are welcome. I would have suggested the same as what you had done, but I was busy with another issue, before I could get back in here before you.
Awesome, thank you guys so much! Nice teamwork :P
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks