Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Can you make an Excel Worksheet unprintable

I asked this question about Word on the Word newsgroup and I am guessing the
answer is the same. Does anyone know how to protect a worksheet so that it is
unprintable? Is there a non-programmable way of doing it?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Can you make an Excel Worksheet unprintable

Nothing built into in excel will stop a user from printing a worksheet.

And if you allowed macros to try to stop the printing, then all the user would
have to do is turn off macros--or even just copy to a different workbook.

You may be able to fool some people for just a little bit of time, by changing
the print range to a single cell (empty).

But that wouldn't stop many -- and it wouldn't stop them for long.



ibvalentine wrote:

I asked this question about Word on the Word newsgroup and I am guessing the
answer is the same. Does anyone know how to protect a worksheet so that it is
unprintable? Is there a non-programmable way of doing it?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Can you make an Excel Worksheet unprintable



"Dave Peterson" wrote:

Nothing built into in excel will stop a user from printing a worksheet.

And if you allowed macros to try to stop the printing, then all the user would
have to do is turn off macros--or even just copy to a different workbook.

You may be able to fool some people for just a little bit of time, by changing
the print range to a single cell (empty).

But that wouldn't stop many -- and it wouldn't stop them for long.



ibvalentine wrote:

I asked this question about Word on the Word newsgroup and I am guessing the
answer is the same. Does anyone know how to protect a worksheet so that it is
unprintable? Is there a non-programmable way of doing it?


--

Dave Peterson


Thanks, Dave!
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
Can I make a Excel Active Desktop Worksheet on XP? Garett Excel Discussion (Misc queries) 1 July 10th 06 05:44 PM
how do i name a excel worksheet and make it appear in cell a1 tthe Excel Worksheet Functions 2 November 16th 05 04:14 AM
How do I make formula in Excel from other worksheet? Ariel in LA Excel Worksheet Functions 1 March 15th 05 10:57 AM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 04:23 PM
Is there a way to make Excel 2000 open a new worksheet in a new w. gdub Excel Discussion (Misc queries) 1 December 22nd 04 03:56 PM


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