Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tim
 
Posts: n/a
Default Can I disable the copy feature?

I have created a spreadsheet, and protected it. However, I can still
copy/paste it into another worksheet and unhide the hidden cells. I wish to
prevent this. Can anyone please provide me some assistance?

Tim
  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default

Tim wrote...
I have created a spreadsheet, and protected it. However, I can still
copy/paste it into another worksheet and unhide the hidden cells. I

wish to
prevent this. Can anyone please provide me some assistance?


The *ONLY* real IP protections Excel provides are file open and file
modify passwords, which function like encryption. However, any file
your users and/or customers can open they can, with VERY little effort,
see *EVERYTHING* in the file. There's NO WAY to disable copying that
doesn't require macros, and it's child's play to disable macros, so
child's play to thwart anything you try to do to disable copying.
Worksheet and workbook password protection is a joke, only useful for
preventing innocent and inadvertent modification.

If you want serious protection for your IP, you've made a *BIG*
*MISTAKE* trying to use Excel as a distribution platform.

Others may offer advice and various bandade solutions, but anything
anyone proposes can be circumvented in minutes by any reasonably
sophisticated Excel user. I'm being harsh because I don't want to
retain any false hope that you can achieve what you seem to want.

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
Copy worksheets with formulas between different workbooks Tim Excel Discussion (Misc queries) 3 March 31st 05 12:40 PM
Copy Function Genie Bohn Excel Discussion (Misc queries) 0 March 23rd 05 12:28 AM
copy in filter mode Excel Worksheet Functions 1 January 8th 05 03:36 AM
Copy and pasting graphs to PowerPoint JZip Excel Discussion (Misc queries) 0 January 6th 05 08:29 PM
Disable automatic date conversion feature iceseal Excel Worksheet Functions 2 November 12th 04 03:04 AM


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