Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default how to disable print button in preview

hOW DO i DISABLE PRINT BUTTON IN PRINTVIEW
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 683
Default how to disable print button in preview

Add the following to your workbook code. Note that if the user has macro's
disabled it will not prevent it.

Private Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True End Sub

"lABUDDY" wrote:

hOW DO i DISABLE PRINT BUTTON IN PRINTVIEW

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
Disable Preview Button in Print Dialog Box Ryan H Excel Programming 0 July 10th 09 03:14 PM
Disable Setup button on Print Preview screen Jon Ley Excel Programming 3 December 3rd 07 09:22 AM
disable page break preview button codysphantom Excel Programming 3 January 19th 05 05:30 PM
Disable Page Break Preview Button John Salig Excel Programming 1 February 10th 04 10:19 AM
How do I disable the Margins button in Print Preview Window John[_35_] Excel Programming 0 July 23rd 03 03:43 AM


All times are GMT +1. The time now is 04:40 PM.

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

About Us

"It's about Microsoft Excel"