Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA or MACRO to prevent someone from printing the contents of an Excel worksheet
Hi,
Does anyone know the macro or VBA code to prevent users from printing a worksheet. They can edit, view, but they CANNOT print the contents of a worksheet. Please explain exactly what I need to do where I place the code and so forth. Your help with this would be greatly appreciated. Please respond via email to: Thanks for any help you may give. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA or MACRO to prevent someone from printing the contents of an Excel worksheet
Place the following first two macros in the WORKSHEET you want to avoid someone from printing
Place the third macro below into a Module Basically they does the following things On activate of a worksheet 1) Disable the "Print" menu ite 2) Replace the Excel shortcut key Ctrl+p with a dummy macro (which contains nothing) On deactivate of the worksheet 3) Reverse (1) and (2) '-----Put in the worksheet----------------------- Private Sub Worksheet_Activate( Application.CommandBars(1).Controls("File").Contro ls("Print...").Enabled = Fals Application.OnKey "^p", "dummy_macro End Su Private Sub Worksheet_Deactivate( Application.CommandBars(1).Controls("File").Contro ls("Print...").Enabled = Tru Application.OnKey "^p End Su '----------------------------------------------------- '-----Put in a module------------------------------- Private Sub dummy_macro( End Su '----------------------------------------------------- Regards Edwin Ta |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA or MACRO to prevent someone from printing the contents of an Excel worksheet
Marcello,
In the ThisWorkbook code module, use Private Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Marcello do Guzman" wrote in message ... Hi, Does anyone know the macro or VBA code to prevent users from printing a worksheet. They can edit, view, but they CANNOT print the contents of a worksheet. Please explain exactly what I need to do where I place the code and so forth. Your help with this would be greatly appreciated. Please respond via email to: Thanks for any help you may give. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA or MACRO to prevent someone from printing the contents ofan Excel worksheet
Edwin and Chip have given ways to prevent printing. But the user may
open the workbook with macros disabled. So you need to make it useless without macros, for example, have a Worksheet_Open show the useful sheet, and hide a dummy sheet that reminds the user to enable macros when opening the sheet. You'll also have to deal with disabling cut/copy, so they can't paste the results into another workbook, and remember to prevent saving, while you're at it. Then protect the code in the VBE, and hope they really don't care much about breaking in. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Marcello do Guzman wrote: Hi, Does anyone know the macro or VBA code to prevent users from printing a worksheet. They can edit, view, but they CANNOT print the contents of a worksheet. Please explain exactly what I need to do where I place the code and so forth. Your help with this would be greatly appreciated. Please respond via email to: Thanks for any help you may give. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent user from copying contents of a worksheet | Excel Discussion (Misc queries) | |||
new worksheet and rename from cell contents macro | Excel Worksheet Functions | |||
How do I prevent cell contents from printing? | Excel Discussion (Misc queries) | |||
How to prevent user from printing in Excel? | Excel Discussion (Misc queries) | |||
MACRO OR VBA CODE TO PREVENT USERS FROM PRINTING THE CONTENTS OF A WORKSHEET? | Excel Programming |