Hello,
I have been wondering if there is a way to prohibit someone from making a copy of a workbook by simple copy and paste function. Thanks.
Hello,
I have been wondering if there is a way to prohibit someone from making a copy of a workbook by simple copy and paste function. Thanks.
-u
Hi ~umesh,
I'm not sure if I am understanding exactly what you want, but I usually compress the entire xls file with winRAR which allows you to password protect the re-expansion of the file. It's inconvenient if you use file often, but it works if you have very sensitive data.
End With
-Jim
Grand Rapids, MI
Hello Jim,
I have a Excel 2003 Workbook which is saved in a network drive. I'm wondering if it's possible to avoid other users who would make a copy of it and paste it somewhere else in its original format (Excel) without a password. I am not sure if this is possible?
-u
What permissions do you have on the network drive? If you have admin rights you could prevent others from accessing file unless they need access to work on this file. You could also move file to a private folder that is not shared on the network. If you do not admin rights on this mapped drive, you can ask an administrator to allow only your user profile to access file.
Hope this helps.
End With
-Jim
Grand Rapids, MI
In the network drive I am just a user but I am the author of the workbook. I am just trying to avoid tampering of the workbook by other users. The data in the workbook must be accessible to multiple users. Is there any way just to prohibit making a copy of the workbook itself?
This is my first post.
As I know, whatever you see, whatever you can copy.
The only way I know is protect the formula only (Format, Cells, Protection, Hidden. Then protect the sheet).
Posting Permissions
Reply With Quote
