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: 3
Default Differentiate between 'Print' and 'Print Preview' in VBA code

Hello,

I have set up some code in a Workbook_BeforePrint Sub to log information as
worksheets are printed. That is, for example, I have sheetA, sheetB, and
sheetLog, and whenever a user prints either sheetA or sheetB, my code will
take some information (e.g., name and date) from that sheet and copy it to
sheetLog.

The issue I have now discovered is that the information will also be logged
if the user merely executes a Print Preview, which makes sense to me. I am
wondering, though, if there is a way to differentiate, in the code, between
an actual 'Print' and just a 'Print Preview'. I am envisioning something like:

If <just Print Preview Then
<don't log information
Else 'actually Printing
<do stuff as normal
End If

Does such a distinction between 'Print' and 'Print Preview' exist?
 
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
Print and Print Preview Graphic Moving Resizing 2007/2003 Adam Rayburn Excel Discussion (Misc queries) 0 April 4th 07 04:18 PM
cell borders that I create dont show on print preview or print scott3435 Excel Discussion (Misc queries) 2 April 6th 06 02:37 AM
Code before Print but not Print Preview widemonk Excel Programming 1 November 14th 05 01:48 PM
Why does macro speed slow after Excel Print or Print Preview? Larry A[_3_] Excel Programming 6 May 16th 05 11:22 AM
Resuming code after closing a print preview DarrenW Excel Programming 1 July 21st 03 02:54 PM


All times are GMT +1. The time now is 09:43 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"