Dear All,
This is kind request that is there any way to prevent other user/computer opening my excel files.
(based on the username of the computer).
Some confidential files need to be maintain privacy.
Is there any solution? Please a help.
Thanks
ebincharles
Hi, ebin charles,
Do not use Excel!Some confidential files need to be maintain privacy.
You could use Environ("ComputerName") or Environ("Username") in ThisWorkbook and Workbook_Open and close the workbook if they do not match but this needs Macros to be activated.
Ciaom
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Excle security is not the best, but you could save the workbooks as password protected. You could then give the password to only those that need to be able to open those files.
Another option, if you are on a network, would be to get the Admin to set up a folder for those files that only designated users have access to. This is not an excel setting, but something the NW admin would need to do
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
Put a password to open on them and don't put them in a shared place
Hello ebin charles,
No matter what you do with your Excel Workbook, i.e., Protection, Passwords, VBA Protection, and whatever, it can be opened in quite a few other platforms or programs like Front Desk or Open Office, just to name a few!
I support what HaHoBe said, "Do not use Excel!"
FDibbins also states that "Excel security is not the best..."
It would seems that you will have to use every available Excel and or VBA Protection available, and then rely on the integrity of the user!
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks