×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

HOW TO COPY PROTECT EXCEL SPREADSHEETS

HOW TO COPY PROTECT EXCEL SPREADSHEETS

HOW TO COPY PROTECT EXCEL SPREADSHEETS

(OP)
I have engineering spreadsheets for engineering calculations which I would like to copy protect.  EXCEL has a copy protection method which allows you to assign a password to copy protect the spreadsheet.  Unfortunately, I have found that if a sheet is copy protected all you need to do is to open up a blank spreadsheet and then copy the and paste the protected sheet into the new sheet.  This removes all copy protection.

Does anyone know a way around this within EXCEL??

If not, can anyone recommend an inexpensive program to copy protect spreadsheets and workbooks???

The more you learn, the less you are certain of.

RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS

Have you tried hiding the worksheet with the calculations and then referencing the results on a second sheet and then protecting the workbook?
TTFN

RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS

If you are worried because you dont want others to "steal" your work then maybe acrobat would be the solution. You can convert the spreadsheet to a PDF file that can only be viewed but not changed - and formulas cannot be viewed.

Best Regards

Morten

RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS

It all depends what you want to do, if you dont want others to use it, then portect the sheet so a password has to be supplied to actually open the sheet, if not id go with IRSTUFF

RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS

(OP)
To IRstuff:  What you propose sound as complicated as what I do now.  Currently to provide a printout of my calculations but keep others from using my spreadsheet, I copy the spreadsheet and then create another spreadsheet and "paste special" the "format" and "values" separately (this hides the formulas and logic).

To MortonA:  Is what you propose easier than what I'm doing as explained to IRstuff?  If so, where do I get Acrobat?

Thanks to all.


The more you learn, the less you are certain of.

RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS

You can get Adobe Acrobat Writer from just about anywhere. The main site is adobe.com, but you can probably find a better deal through pricegrabber.com.

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS

If all you want to do is to present the results and not have live calculations, Acrobat is certainly an option, but you could simply copy the spreadsheet into Word and paste special as a bitmap, which is what the Acrobat file winds up being in anycase.

TTFN

RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS

IRStuff:

Hiding a worksheet and then protecting it may work, but it is relatively simple to crack passwords on worksheets.  (I lost a password one time and it took me about 5 minutes searching the net to find a utility to do it.)

Perhaps a better way...

If you can find a way to make it work, you can use add-ins.  I have created spreadsheets that had pretty complex calculations, hidden the sheet, and saved it as an add-in.  For my particular application, it worked pretty well.  And you can password protect the add-in so others can't see it.  (Your basic user won't even have a clue how to look for it.)  The password protection on the add-ins is better than on the worksheets.  It will probably take you a while to get your add-in working properly, but once it does, boy is it slick.  And once you've gone through the painful process of doing this once, you'll find all kinds of new uses for this technique.

You might want to resubmit this question in the Tek-Tips forum.  Some of those guys over there are wizards with excel.

RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS

To reichertc
Password protection on the add-ins is no better
than on worksheet and for seeing just click
Alt+F11.

RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS

(OP)
I do not use Word because it will not retain the formatting in my spreadsheet which is important to me.  I think in summary I may be just as well off doing what I'm doing.  Thanks to All - I did get some additional ideas.

The more you learn, the less you are certain of.

RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS

Both paste special bitmap and Acrobat distiller should preserve format as printed.

TTFN

RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS

My opinion is that spreadsheet is a only a tool  - we do not recreate the wheel by using it. The calculations what we may be doing is actually quite known only the techniques may be unknown. I feel by letting others to use your spreadsheet only elevates you to a level where you still remain superior. If you really want to use a copyright Excel is not the right application. Better adapt to other ways to make you sell.

Samiran

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close