Re: Excel question...I'm in a meeting

[Peter <pnewman1 -at- home -dot- com>]

John Posada wrote:
> 
> Hi, guys...quick question...I'm in a meeting and someone brought up a
> question, so I don't have my resources with me.
> 
> Is there a way a protecting an Excel spreadsheet where you cannot
> copy, via copy/paste, the vales and formula from one spreadsheet to
> another?
> 

Yes off the top of my head I can think of several ways. 
1. save the sheet with password protection turned on and formulas
hidden.
2. print the worksheet as a PDF file.
3. call the sheet into VB as a view only object.



-- 
Peter
Mailto:peternew -at- optonline -dot- net

Adapting old programs to fit new machines
usually means adapting new machines to
behave like old ones.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Be a published author!  iUniverse gives you: a high-quality paperback, a
custom cover design, and distribution to 25,000 retailers.  And it's
affordable.  Join our almost 10,000 published authors today.
http://www.iuniverse.com/media/techwr

  Your monthly sponsorship message here reaches more than
  5000 technical writers, providing 2,500,000+ monthly impressions.
  Contact Eric (ejray -at- raycomm -dot- com) for details and availability.

---
You are currently subscribed to techwr-l as: archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot-  Visit 
http://www.raycomm.com/techwhirl/ for more resources and info.