I am storing a list of users and their passwords in a worksheet. I do not want other users to view the passwords. The passwords are used for opening other workbooks. Currently I have changed the text color to white to hide the passwords. Is there a better method ?
Last edited by anandvh; 01-10-2012 at 10:59 AM.
Hide the Sheet or better still hide it from the VB Editor .
Open the VB Editor
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
The sheet should be selected in the Project Window
Scroll down the worksheet's Properties & Find the Visible Property
Change to VeryHidden
No-one can unhide without using VBA or accessing the VB Editor
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Thanks Roy. This is very simple to implement. I was breaking my head trying out encryption methods.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks