Generate Usernames & Matching Passwords

Jun 7, 2009

I need some code that will generate passwords from a combination of a master password and other words such as a user name. I have seen references to use of the MD5 algorithm but would not know if or how this could be incorporated into vba.
This would be used in an workbook which is distributed to different users. In order to use the workbook, they would need to enter their user name and password. The macro would check if these were correct or not. Because the password is generated by the macro, it avoids having to have them hidden in the workbook somewhere.

View 5 Replies


ADVERTISEMENT

Auto Generate Passwords

Nov 24, 2008

Is there a way to auto generate passwords? I would like the result to start off with the word "cook" and end in numbers. Is this possible?

Password: cook###

View 7 Replies View Related

Generate Unique Log In Passwords

Aug 26, 2006

I have a list of e-mail addresses stored in an Excel file (column A). I need to generate some passwords basing on these e-mail addresses which would then be automatically stored in the same row as the passwords, only this time in column B. The passwords could be numbers based on some text to number conversion (which I could additionally add some mathematical operation to, to make the password harder to crack). The passwods would then be distributed among the owners of these e-mail addresses.

View 5 Replies View Related

Automatically Generate Passwords For Multiple Sheets

Feb 20, 2014

I have a workbook in which users record the time spent on various activities. I have some code which will copy the worksheet template and create a worksheet for each user (in a defined list of names). Then each worksheet needs to be password protected so only the user can see it (I can do this individually by manually writing in each sheet name and setting a password but will have 80+ users for some groups and it will take ages...)

What I would like to be able to do is also automatically generate a password for each user (combining a word and automatic number e.g. "EMidsTeam123") it may be possible to insert this into the code I already have (which I have copied )...

VB:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Dim strPass As String
Dim lCount As Long
If Sh.CodeName <> "Sheet1" Then
'Set sLast variable to the last active sheet This is then used to return the user to the last sheet they were

[Code]....

View 6 Replies View Related

Insert Usernames Into Range

Jul 30, 2007

I am trying to write a code which automatically inserts the users username in a cell once a macro button is pressed.

Sub Approve()
If ThisWorkbook.HasRoutingSlip = True Then
With ThisWorkbook.RoutingSlip
.Delivery = xlOneAfterAnother
Sheets("infosheet").Select
.Subject = "Here is " & ThisWorkbook.Name
.Message = "Here is the workbook. What do you think?"
End With
Workbooks("myfile.xls").Route
End If .....................

View 9 Replies View Related

Macro - Query Active Directory With Multiple Usernames

Apr 13, 2014

I am trying to query Active Directory for a list of user attributes by using a list of usernames and output the results into column B,C,D.....

All the usernames are listed in column A and it ranges from 100 to 1000 usernames.

The macro GetAdsProp works but it is very slow because it's a function and every time it gets called to return a value, it takes a long time to query. It will take forever to get 1000 users.

I've also tried the code below, however one of the AD attribute that I am querying for has a dash (i.e. test-address) and I can't put a dash in the vba code because it automatically puts spaces in between the dash and the text (see red text below) which will fail to find the attribute. Also, I need it to loop the whole column A and not just one account.

Sub LoadUserInfo()
Dim x, objConnection, objCommand, objRecordSet, oUser, skip, disa
Dim sht As Worksheet

' get domain
Dim oRoot
Set oRoot = GetObject("LDAP://rootDSE")

[Code] .....

View 3 Replies View Related

Two Different Passwords Without Debug

May 9, 2008

I have a problem with a HUGE macro project I'm working on. The macro itself isn't huge, but it's being applied to about 10,000 files. The macro is updating information on three spreadsheets in each workbook, but the problem is that the password protection (and Macro in general) fails to unlock when the password was entered in UPPERCASE. So the password is "king" and/or "KING" depending on the sheet. There is no way of predicting which sheets will be caps and which will not, but it's frustrating when my macro stops every 5 files with an error because of a wrong password (even though it's always one of those two).

Is there an IF THEN statement or something that I can do so that the macro doesn't stall every 30 seconds to 2 minutes... I have 10,000 files to crawl through.

View 10 Replies View Related

Controlling Several Passwords

Jul 28, 2006

how to liberate only the sheets already opened by this user, even after he/she has closed the workbook? It means that when this user re-open the workbook, only the password for this step (workbook) and of course for the sheets still closed (not yet visited), will be requested...

There will be about 20 users, accessing the same file (at least 8 or 9 at the same time), and each one has a different level. For this reason the workbook is also protected: depending on the username and password, I'm trying let excel "knows" what sheet each user can open, without type a password again. trying to illustrating: (all users and password are added by me, using a MasterSheet)

user1 ----- already unprotected sheet9 ----- can open sheet1 to 9 (no password, even re-opening the workbook)
to open the sheet10, a username and a password are required

user2 ----- unprotected sheet3 ----- can open sheet1 to 3 (no password, even re-opening the workbook)
to open the sheet4, a username and a password are required

............. and so on.........

View 4 Replies View Related

Passwords And Drop Down Lists

May 3, 2009

How would I write a marco that requires a password when a certain word in a drop down list is selected, bearing in mind that when this word is selected certain cells in the worksheet are no longer locked - in other words the certain cell can only changed by a specific person in the drop down list which when this person is selected a password is required.

View 14 Replies View Related

Removing All Passwords From Whole Workbook?

Mar 10, 2014

I have a workbook that has data that I copied over from another workbook that had a password connected to it. I want to remove it, as when I click enable content it is asking for the password from these old documents. I know the passwords, but do not want them to pop up.

View 3 Replies View Related

Hidden Tabs And Passwords

Oct 13, 2007

I have been doing a lot of reading on the forums here on hiding tabs and passwords for my current project...and suffice to say I am completely...totally...stuck.

Basically, I have 11 different tabs that need to remain hidden until, the person clicks on a commandbutton which brings up a userform that asks for a password.

Now - I have it set up that the user prior to this stage chooses thier location and it populates a label1 field on the password request userform.

My biggest problem is this: I cannot seem to figure out how, in using a userform, to get the password to be recognized as TRUE....here is the
Private Sub TextBox1_Change()
a = UserForm12.TextBox1

If a "password" Then
MsgBox "Wrong Password"
Sheets("RatesII").Visible = xlSheetVeryHidden
End If
End Sub

Now, my idea is that once the correct password is used, the userform dissmisses itself, the correct sheet is activated and unhidden for viewing and the user goes about doing what they do on this sheet. I will also have a button on the sheet itself titled something like "Update" which will save the sheet, and re-hide it and call up the userform once again...something I am a little scetchy on at this time though I immagine I will figure it out.

View 9 Replies View Related

Preventing Users From Using Passwords

Mar 18, 2008

I have made an integrated timesheet for everyone at work. Problem is, people will be funny-beggers, and want to password protect their workbooks.

I want to be able to prevent EVERYONE from creating passwords to protect their workbook.

View 9 Replies View Related

Multiple Passwords In 1 Workbook

Nov 3, 2006

My workbook contains a number of worksheets - currently nine. Each worksheet details a specific "business unit" for the company I work for. Using VB, is it possible for Excel to request a password upon opening the workbook? If so, the specific password input would determine the specific worksheet(s) that are available for viewing.

View 3 Replies View Related

Create Alphanumeric Passwords

May 14, 2007

I would like to use an excel spreadsheet to generate a series of passwords. The password must include alphanumeric content, and be at least 10 characters long, and case sensitive.

For example: 14sH2dA456a

Thought about concatenting each variable, but do not know how to control the random variable creation in a spreadsheet?

I have looked at RAND but can't figure out how to use it to any avail?

View 9 Replies View Related

Protecting Sheets With Multiple Passwords?

Jan 29, 2014

I have different sheets in my workbook for which i have different passwords with which i need to protect each sheet with the password assigned to it.

Is it possible to do a macro which automatically protect the sheets with the correct password.

I have attached a sample workbook the sheet "passwords" will have sheet names in first column and respective passwords in the second column.

View 6 Replies View Related

Protecting Document With Multiple Passwords?

Feb 17, 2014

I have recorded a macro and added this to a button on the document. I was wondering if it will be possible that each user who works on the document can use a specific password to unlock cells and autolock once document is saved. I have a seperate document that has the users and their specific passwords on.

View 1 Replies View Related

How To Apply Different Passwords To Each Columns Without Protect Worksheet

May 9, 2013

In the attached file, I need four different passwords for Columns D, E, F, & G Respectively.

I had gone though below link and partially I could able to achieve what I need.

[URL]

However, the problem is at the end of this process we have protected the worksheet as well. This is not feasible for the process what I am working on.

how to apply different password without protecting worksheet.

View 5 Replies View Related

Multiple Users With Passwords And Admin Can View All Of Them

May 28, 2014

The problem - there are multiple users, each one has its own excel file, but it has to be password protected. I assume there is a simple VBA script or something. I found something here - User name and password to open excel file . I guess I don't need it to be that complicated. I haven't gotten it to work yet, so I can't tell if it's what I need.

Also there is an Admin or whatever that has to view all of the users excel files in one excel file. Is this even possible?

View 1 Replies View Related

Multiple User Logins & Passwords In Workbook

Nov 4, 2006

how to create user logins and passwords for five users for one workbook. Also, preferrably to have a message to prompt for entering the user name and password at the first worksheet (e.g. the main page where there it is usually the company logo page) when the workbook is open.

E.g. there are five employees and we would like to create five different logins and passwords for them. So when they open the workbook, it would be the first sheet of the workbook to appear first and they would then be prompt to enter their username and password. If one of the employees leave the company, we can still quite easily change the name to the new employee.

View 6 Replies View Related

Excel 2010 :: Protect Worksheet With Multiple Passwords

Feb 16, 2014

I have an excel file with three worksheets in it. I can happily protect each sheet with a different password but what i want to be able to do is the following:

a. have a global administrator password for all the sheets - so i assume set the same password to protect the whole sheet
b. have individual passwords that only allow the user to insert rows and change data within restricted columns, i.e. can only edit columns A:Z and cannot manipulate any formulas within that range A:Z

I have excel 2010 if that makes any difference.

View 2 Replies View Related

Excel 2010 :: Hiding And Locking Columns And Formulas Together Via Passwords?

Mar 8, 2014

Is there a way in Excel 2010 that the administrator of a excel document can not only hide some columns but lock the columns by some kind of password so it remains hidden? I know user can hide/unhide columns but can some columns be hiddens and locked with passwords?

Secondly can formulas like IF and vlookups statements be hidden and locked with some kind of password?

In maybe via VBA or by some other means, is this possible?

The end user should only be able to type and select certain cells only.

View 5 Replies View Related

Password For Custom Userform Login Only Works With Text Passwords?

Mar 21, 2014

Im using the following code on a User login userform. This code is for the Login command button to access the workbook (the user clicks on it after entering there username and password).

For some reason if the password is numbers only it just returns message box "Incorrect password, try again."

As soon as I put a single letter into the password it works fine,

[Code]....

View 4 Replies View Related

Compiling Partially Matching Data Into Matching Rows With Macro

Jan 20, 2013

My task is to combine two large databases into one spreadsheet by extending the number of columns. The data from each database is 90% matching based on an identification number, however occasionally there are additional rows or unmatched identification numbers that need to be kept for analysis.

When this happens, there needs to be a blank row inserted to represent the missing data in the rest of the corresponding row.

I am having trouble finding a quick way to do this because I have approximately 12,000 rows (and columns up to DV when combined).

for example:

p1
data
data
data
data
p2
data
data
data
data

[Code] .....

needs to become:

p1
data
data
data
data

[Code] .....

I am guessing I will need a macro of sorts, So far I have made one column that tell me if the ID's are matching or not (1 or 0) and if they are not matching (0) I manually insert the rest of the row that is missing or make space for the duplicate data (which needs to remain).

View 5 Replies View Related

Bank Reconciliation - Many To One Matching And Partial Cell Matching

Nov 19, 2009

programming 2 macros in a bank reconciliation sheet I am trying to create.

Basically the data consists of two sets: the ledger side and bank side. Both sides consists of multiple columns that include date, description and amount.

The following two situations can occur and which need to be covered with a macro.

Many to one matching
When we make payments to say 100 different suppliers at once, the ledger side will show 100 lines with the different amounts. However on the bank side it will only show one line with a total amount for the transaction. As the description on the ledger side is the same for all transactions done at the same time, it should be possible to have a macro add these lines and compare the total with entries on the bank side. Once a matching amount has been found, the macro should place an ‘x’ next to all entries on the ledger and bank side, in order to show that these transactions have been reconciled.

Partial cell matching
In this case we are only dealing with one line on both the ledger and bank side. The issue is that the description does not always perfectly match with one another. The ledger side might say ‘Brown Corp.’ and the bank side might say ‘Brown Corporation’. I want to come up with a macro that can recognize this partial match and still reconcile the lines by placing a ‘x’ to both the ledger and bank entry. The match however should be done with a combination of description, date and amount as several different bookings might be done for the same supplier in the same month.

View 12 Replies View Related

Matching Two Tables - Copying Data For Matching Value?

Feb 27, 2014

I have two tables, Table1 one has only customer codes in it, and I have Table2 with plenty of customer codes and those customer name, surname, age, location...

And I want to match and copy each of those customer codes in Table 1 all the information which is on Table2

Table 1:
50025
50026
50086

Table 2: Considering that name, age and location is each in separate cell

50025JohnSecond25Location 1
60085EmilyThird 20Location 2
45454Wilhelm Fourth35Location 3
10000RoseFifth 60Location 4
50086JohnySixth 45Location 5
65501JacobSeventh18Location 6
50026Jackie Eighth22Location 7

And the outcame should be that it finds the value from Table1 in Table2 and copy's information in Table 1 like this:

50025 JohnSecond25Location 1
50026 Jackie Eighth22Location 7
50086 Johny Sixth 45Location 5

View 2 Replies View Related

Copy Matching And Non Matching Data Into New Worksheet

Feb 20, 2014

I have two worksheet "ABX" and "ACX" from which I want to find the matching data for specific columns B, D and E only.

Matching data will be in sheet "Match" and vice versa.

Data are present dynamically.

View 1 Replies View Related

Align Matching Row Values Column And Remove Non-matching Row Values?

Jan 27, 2014

see attachment below for easier comprehension of what I need to be done. Note that I have around 20 subjects (2 in example) and about 15000 values per subject (5 per subject shown) Basically, I want matching rows to be aligned (see grey) and non-matching rows to be deleted, throughout the 20 or so subjects.

Exemple.xlsx

View 6 Replies View Related

Matching Cell Formats Based On Matching Cell Values

Jan 28, 2010

I have a cell (A1) that contains text.
That text will match a single value in a reference list (i.e. range of cells e.g. Z1:Z26).
When the match occurs (e.g. A1 = Z16), I want the format of the reference cell (fill color, text color) to apply to the cell of interest (A1).
The reference cells are manually formatted.

I know that I could create a long list of conditional format formulas instead of using the reference, but it seems that there must be some way to tell excel: if the cell value contents are equivalent, the formatting should be as well.

View 9 Replies View Related

Generate A Listbox

Oct 3, 2008

I have a list of names on a worksheet in cells C9:C:C395. Their respected team numbers are located in G9:G395. What I'd like to know is it possible to put a team number in lets say cell K2 and have a listbox appear with the names of each of the team member from that team.

View 4 Replies View Related

Generate PDF With All Sheets?

Mar 12, 2014

I have a big Excel file with 20+ sheets. All these sheets have different margins and layouts.

I need to generate a Single PDF with all these sheets. Is it possible?

When I save the file as PDF, it converts only the current sheet and NOT the whole file. As I said all my sheets have different margins and layouts, I can not combine them into a single sheet.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved