Hi all,
Please help me to understand, as how to lock a cell content...Means no one should try to edit the cell content...May be with a Password ?
Other cells can be editted.
Thank you
Mani
Hi all,
Please help me to understand, as how to lock a cell content...Means no one should try to edit the cell content...May be with a Password ?
Other cells can be editted.
Thank you
Mani
You can save the file with a password, with a read-only option. Doing this means that others can open the WB, they can even make changes - but they will NOT be able to save the file at all, so it will always remain how you last saved it
To do this, click file/save as, select Tools/General Options, and select Password to Modify
Note, you MUST remember your password, there is no way to recover it if you loose it
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