Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007: Disable printing but still able to view Print Preview
Hello,
I am trying to disable all printing when a specific cell on a worksheet is blank. Meaning there is no way a user can print anything from the worksheet until the cell has been filled. Also, I need to be able to view the print preview screen of the sheet....just not be able to actually print the sheet. Any code samples or examples would be both appreciated and helpful. This example needs to work for Excel 2007. Working for any other versions is not mandatory but it is a bonus. Thanks for the help in advance, Aaron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007: Disable printing but still able to view Print Preview
I don't think you can do it. The workbook event that you'd want to use is
workbook_beforeprint, but it can't tell the difference between printing and previewing. Aaron wrote: Hello, I am trying to disable all printing when a specific cell on a worksheet is blank. Meaning there is no way a user can print anything from the worksheet until the cell has been filled. Also, I need to be able to view the print preview screen of the sheet....just not be able to actually print the sheet. Any code samples or examples would be both appreciated and helpful. This example needs to work for Excel 2007. Working for any other versions is not mandatory but it is a bonus. Thanks for the help in advance, Aaron -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007: Disable printing but still able to view Print Preview
Also no way to stop print button in preview i think
"Dave Peterson" wrote in message ... |I don't think you can do it. The workbook event that you'd want to use is | workbook_beforeprint, but it can't tell the difference between printing and | previewing. | | | Aaron wrote: | | Hello, | | I am trying to disable all printing when a specific cell on a worksheet is | blank. Meaning there is no way a user can print anything from the worksheet | until the cell has been filled. Also, I need to be able to view the | preview screen of the sheet....just not be able to actually print the sheet. | | Any code samples or examples would be both appreciated and helpful. This | example needs to work for Excel 2007. Working for any other versions is not | mandatory but it is a bonus. | | Thanks for the help in advance, | Aaron | | -- | | Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell 2007 - Group of Charts Print Preview and/or Printing problems | Charts and Charting in Excel | |||
2007 Print Preview Issue when printing multiple sheets | Excel Programming | |||
print preview does not view landscape set up | Setting up and Configuration of Excel | |||
Docs printing smaller than print preview now that 2007 installed | Excel Discussion (Misc queries) | |||
Can view file in print preview, but not print layout.... | Excel Discussion (Misc queries) |