MS Excel Tips - Avoiding Users Printing an Excel Workbook
In Excel you will possibly not always want users every single child print a work book.This can be because it includes sensitive information and you also will not want so that it is printed and left in an office, or maybe worse a customers office that you'll be visiting.This has been done. Often!
Whatever that are used for preventing printing, the easiest way to accomplish this is to create a macro to cancel the printing job before it even starts.
A macro in Excel is a symbol, name or key signifying a summary of commands, actions Cisco 642-648 key strokes with your keyboard.Many programs including Excel assist you to create macros to so you can enter a single character or word to perform a whole group of actions. Macros are essentially like programs are batch files which conduct a selection of instructions you could program.Macros are fantastic for reducing a serious amounts of resources in many ways by automating some simple repetitive procedures to helping with security just as this situation we've been discussing today.
The macro to stop a person printing a piece sheet incorporates a message box to warn anyone actually can not print the project book.Including this warning is helpful from the example as the print controls are positioned on being a function in Excel in addition, on the job book.
In order to have this macro installed and operating you will need to carry out the following in Excel:-
Open inside the Visual Basic (VB) editor in Exel by punching the ALT F11 keys
Click for this Workbook inside while in the Project Cisco 642-780 VBA window
You will now start to see the This Workbook Code Module
Double click to look at it
Enter the code below in the This Workbook Code Module
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
MsgBox "You can't print the job sheet", vbOKOnly, "Error"
Close the Visual Basic (VB) editor in Exel by punching the ALT F11 keys
Save your work book
Your macro will now be saved in the job book.
You can test the macro by selecting to print the workbook.When this is attempted whole body message 'You can't print the job sheet' looks.You may customise you message dispayed if you wish to.All you have to is replace 'You can't print this work sheet' with all your chosen text.
The work book is already secured the job book from the unintentional printing by any users.
|Letzte Einträge: MS Excel Tips - Use Conditional Formatting To search out Duplicate Data, MS Excel Tips: Chose the Contrast between Two Dates Using DATEDIF, MS Excel Tutorial - Creating And making use of Named Ranges, MS Excel Tutorial - How to operate the Concatenation Function In Excel, My Top iPad VPN Accessories for Business, Nearshore Software Developers - Five Compelling Reasons to Use Them|