Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Code before Print but not Print Preview


How do I determine the difference between print and print preview i
VBA?

I want to run a bit of code in the 'before_print' procedure but
*-don't-* want it to run if its just print preview.

Anyone have any ideas ??

Thank

--
widemon

-----------------------------------------------------------------------
widemonk's Profile: http://www.excelforum.com/member.php...fo&userid=2040
View this thread: http://www.excelforum.com/showthread.php?threadid=48397

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Code before Print but not Print Preview

As far as I know, there is no way to determine the difference
between Print and Print Preview.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"widemonk"
wrote in
message
...

How do I determine the difference between print and print
preview in
VBA?

I want to run a bit of code in the 'before_print' procedure but
I
*-don't-* want it to run if its just print preview.

Anyone have any ideas ??

Thanks


--
widemonk


------------------------------------------------------------------------
widemonk's Profile:
http://www.excelforum.com/member.php...o&userid=20402
View this thread:
http://www.excelforum.com/showthread...hreadid=483978



Reply
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
Plot Area Automatically Expands in Print and Print Preview Myk D. Charts and Charting in Excel 2 March 12th 09 01:41 PM
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
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 01:31 AM.

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"