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???
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
TTFN
RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS
Best Regards
Morten
RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS
RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS
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
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
TTFN
RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS
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
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
The more you learn, the less you are certain of.
RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS
TTFN
RE: HOW TO COPY PROTECT EXCEL SPREADSHEETS
Samiran