Hi,
I know I can lock the excel workbook Tool/option/security or when i save general option but is there way lock with VBA ? so is there macro when you tty to open file it ask for password to open.
Thanks
RR
Hi,
I know I can lock the excel workbook Tool/option/security or when i save general option but is there way lock with VBA ? so is there macro when you tty to open file it ask for password to open.
Thanks
RR
You can apply passwords through VBA, but excel's security is notoriously weak and easy to get around
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
Sorry, not quite understand. is there way to do it or not ? if yes then how ?
Any suggestion ?
Yes this can be done, but it will not be very secure. I am not able to do it, but many other members can, I am just letting you know that it will not be very secure, anyone with some VBA knoledge may be able to get around it
Bumped up ...... ???
Last edited by robrobet; 10-30-2013 at 11:43 PM.
Anyone else able to help with it ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks