Good Day,
Is it possible to protect an excel file from being copied or password protect the file for opening?
Thanks
Martin
Good Day,
Is it possible to protect an excel file from being copied or password protect the file for opening?
Thanks
Martin
Hi
Yes, you can. Under REVIEW menu you have the option to "PROTECT SHEET". Try it.
Good Day...
Click *, if my suggestion helps you. Have a good day!!
you can protect the file from being opened, but you cannot stop it from being copied. However, if the file is password proteced, the password protection will be copied with it.
However, please note that excel password protection is not the greatest in the world. although it will stop the average user from opening the file, some-one with the necessary slills will be able to open the file
to password protect an excel workbook, select file/save as/tools/general options/select which 1 you want.
make sure that you put the P/W some place safe, if you dont, and forget it, you will not be able to open the file (read above though)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks