• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can we create LOG in and Password in excel ?

Hi ,


Have you checked out the following ?


1. http://www.ozgrid.com/forum/showthread.php?t=32869&page=1


2. http://www.excelforum.com/excel-programming/577224-login-form.html


Narayan
 
If having a single password for everyone to use is acceptable, without separate logins, check the following:

http://office.microsoft.com/en-us/excel-help/secure-a-workbook-with-a-password-HP001112410.aspx


Excel does not have built-in login capability.


Typically file access per user is handled by network security, and then the users have to be trusted to not redistribute the file. For this, just locate your file on a network share that the desired users have access to.


Asa
 
THe link is about Applying Password protection!! well i know how to apply password protection! well i want to create login ids and passwords!...so only specific users can open the workbooks simple!...
 
Gotcha. I was listing alternatives to the VBA code already linked. i.e. Workbook/worksheet protection or network security (which is the most common way to restrict access).


If you want or need the workbook to have it's own login system, then I have nothing to add to the previously linked VBA macros. I have never done it. If you try to use one of those examples or pose some specific questions re. problems, if any, encountered, I may be able to help more. Of course, maybe someone else here at chandoo has done it themselves and can step you through the process.


When you refer to a "template" I know at least one of those two links actually had a workbook with a working setup in it -- is that what you mean by a template?
 
Hi ,


The ozgrid link has a complete working template. If you do not wish to register at that website , I can copy + paste from there.


Narayan
 
how to i reply there!...am not able to see the reply tab!...

and i have downloaded the excel file..but!,,, there are 2 sheets hidden and i want to unhide them!..but not able to do so!..
 
Just an additional warning, XL should not be used a completely secure database. No amount of passwords (either internal or through coding) can stop someone determined enough. If the intent is simply to keep people from messing things up, or prevent the accidental viewing, you're okay. If you're storing sensitive data (SSN's, salaries, etc), you need to use an alternative method.
 
Thanks for Jumping in Luke :)...well what are the alternative methods?...well remember the project u helped me with is sensitive data!..and need few ppl to access it others only view it!..so no 1 can mess or take the codings from it!...my Operations manager told me to get Login password in it!...just due to that :(((....

and need your help in another thread as well "EXCEL FORMULA" i have uploaded a sample workbook as well
 
take a look here at a rundown of the different protection options, as well as there pros/cons:

http://spreadsheetpage.com/index.php/tip/spreadsheet_protection_faq1/
 
You must log in or register to reply here.
Back
Top