Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I think you would need a macro to do that. You would have to place the macro
in the "BeforePrint" event which is in the "ThisWorkbook" sheet/folder. You could say something to the affect that if the sheet name is "yoursheetname" to cancel the print request. However, you may also have to do something if the user is on another sheet and asks to print the entire workbook from the File/Print menu. Try posting the question in the Programming discussion group. Hope this helps. Bill Horton "Efzed" wrote: I want to know if there is any way where even if you click the PRINT icon in excel, the particular worksheet will not print. In other words, I want to restrict printing a worksheet in a workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing Specific data from Excel worksheet | Excel Discussion (Misc queries) | |||
Prevent Printing of Specific Cells | Excel Discussion (Misc queries) | |||
Disable printing a spreadsheet until assinged cells have data | Excel Worksheet Functions | |||
Determining and Printing a specific page | Excel Discussion (Misc queries) | |||
Disable Printing | Excel Discussion (Misc queries) |