LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
Abhishek kedia
 
Posts: n/a
Default protect a sheet from being printed?


Hi
JE McGimpsey

I tried it, but unforunitly it does not work, can u explain in detail

Thanks

Abhishek kedia
"JE McGimpsey" wrote:

Prevent? Yes, it's impossible.

Make it somewhat difficult for a novice user? Sure. Put this in the
ThisWorkbook module of your workbook:


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

However, this will not prevent anyone from printing a screenshot.


In article ,
RVal wrote:

I am trying to stop anyone from printing a spreadsheet. Is this possible?


 
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
How do use list with protect sheet function? quantn Excel Discussion (Misc queries) 0 February 18th 06 05:56 PM
how do I protect formula's only, not entire sheet or book? Beginner Excel User Setting up and Configuration of Excel 2 February 16th 06 09:07 PM
How to protect sheet but allow grouping to work dwsmha Excel Worksheet Functions 1 August 30th 05 12:53 AM
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 04:41 PM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


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