LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 287
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excell 2007 - Group of Charts Print Preview and/or Printing problems Elmtree via OfficeKB.com Charts and Charting in Excel 3 September 5th 08 04:10 PM
2007 Print Preview Issue when printing multiple sheets [email protected] Excel Programming 0 March 19th 08 12:38 PM
print preview does not view landscape set up french99 Setting up and Configuration of Excel 2 April 12th 07 09:14 PM
Docs printing smaller than print preview now that 2007 installed j9 Excel Discussion (Misc queries) 0 March 5th 07 05:21 PM
Can view file in print preview, but not print layout.... kkaden Excel Discussion (Misc queries) 1 March 22nd 06 05:54 PM


All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"