Administrator Privilege Not Working On Login Form

Jan 30, 2014

I have a workbook (attached) which has a button that would enable a user login using a username and a password. The usernames and passwords are configured on an hidden sheet (config) in Columns A to D. In column D, access level is selected to be either "FULL" or "LIMITED" which gives access to an extra button which enables user to be able to create new users, change passwords and all.

The issue I have is, the user I have configured to have FULL access does not have it as the button which gives access to this functionality does not come up.

ADMINISTRATOR 1 - password1 (has full access)
ADMINISTRATOR 2 - password2 (has limited access)
ADMINISTRATOR 3 - password3 (has limited access)

Please see attached Login Sample.xlsm.

View 7 Replies


ADVERTISEMENT

Using VBA To Complete Login Form

Jan 13, 2014

I am attempting to use VBA to open a webpage and then login. Below is the code I have so far:

Code:
Sub Test()
Dim IE As Object
Set IE = New InternetExplorerMedium
With IE
.Visible = True
.navigate ("url")

[Code] ........

Here is the HTML Code of the website:

<form target="_top" name="Logi<wbr>n" method="POST" action="/login.fcc"></form>

<label for="firstname">User Name</label>
<input class="textbox2" onkeypress="javascript:processkey(window.event)" name="USERNAME" type="TEXT">

[Code] ........

An error occurs within the second With, stating that the object variable or With block variable not set.

View 5 Replies View Related

Login Form - User Access

Jun 4, 2014

I have a userform (Login), which allows you to login by entering your username, password and by selecting your role.

When you enter the username, password and role and click on submit, it shows another userform (Activities).

Now what I want is, when i enter username, password and select the role as team manager and click on submit, it should show the userform - "Manager_Login". For all other roles, it should show the userform - "Activities".

The usernames, passwords and roles are on the sheet - "User Access".

View 3 Replies View Related

Excel 2010 :: Userform As Login Form - VBA To Validate Username And Password

Jun 18, 2012

Using Excel2010 in Windows7. I have a UserForm

1: TextBox for Input Username (txtUsernameIn)
2: TextBox for Input Password (txtPasswordIn)
3) Submit Button (cmdSubmit1)

I have a Worksheet
ColA: Username
ColB: Password
And this entire Range A:B, I have named "UserRegister"

I have code, attached to the cmdSubmit1 button on my UserForm. The purpose is to allow access to a veryhidden Worksheet "ADMIN".

The code 'works' if I enter in both the correct UserName and Password (ie: the code completes & Admin sheet opens up).

The code 'works' if I enter in the correct UserName and the wrong password (ie: code completes it's run, my msg pops up to say there is wrong input, unloads the form & sheet ADMIN stays veryhidden).

However, if I enter the wrong username (with either right or wrong password) the code breaks and I get a debug error. I know my code is obviously wrong/missing something etc - but I can't work it out! The line of code highlighted on the break, is between the *** below

VB:
Private Sub cmdSubmit1_Click()
Dim Username As String
Username = txtUserNameIn.Text
Dim password As String
password = txtPasswordIn.Text

[Code] ......

View 9 Replies View Related

Change Administrator Name / Writer Name And Last User Name

Aug 14, 2014

How can I change; Administrator name, Writer name and Last user name with vba code ?

View 7 Replies View Related

Excel 2010 :: Password Protect Document At Administrator Level

Oct 2, 2012

Excel 2010, Windows 7: Is it possible to password protect an Excel document at an "Administrator" or a executive level. I want to grant access to the document, and the ability to manipulate it as they choose, to everyone with the password but prohibit them from changing the password once they are in.

View 1 Replies View Related

Form Not Working If Other Workbooks Are Open

Mar 24, 2009

I've been developing a form in excel (not userforms, just the usual conditional formatting, validation and macros to show/hide rows etc). It all works fine now except one thing was noticed when a colleague was testing it. If she opens the form from the email, and she already has excel open, then the form will not work when she makes a selection from the dropdown list, which unhides the rest of the form. If she closes down all of excel and opens the form from fresh, it works fine.

View 9 Replies View Related

Stop Close Form Button Working On Userforms

Jul 16, 2007

I have a useform that loads up with two buttons and I waat to force the user to chose one of the buttons. However, I have noticed that the user can just press the cross in the top right corner of the form to close the window and therefore not press either button.

Is there anyway I can stop the close form button working?

View 4 Replies View Related

Login Using VBA

Jul 20, 2009

I need to create a login username and password form which pops up when excel worksheet is open

Does anybody know the instructions for this task

View 9 Replies View Related

Vba Login To Internet

May 13, 2008

how can I login to a website using vba. I googled many examples but still failed.

View 9 Replies View Related

Creating A Login Box

Apr 20, 2005

I want it so that when the workbook opens it prompts for a username and password. You can also have a button for "register" etc. Which will send you to a website.

View 9 Replies View Related

Login To Web Page Via Add-in

Jan 14, 2008

I use a tool that connects to Salesforce.com. It is an xla addin. It references a toolkit that is installed...

View 3 Replies View Related

Username / Password At Login

May 31, 2013

I have below piece of code which I'm not sure how to finish up. What I'm trying to do is have 'Username' and 'password' entered before logging into the workbook. It does not have to be 'UserForm" if it is possible, but it would be useful if we use Ucase...

I'm just not sure how this code works with

"Sub sUserLogon(strStandardID As String, strPassword As String)"

stated in this way..

VB:
Sub sUserLogon(strStandardID As String, strPassword As String)
Dim strUserName As String
Dim StrMessage As String
Application.DisplayAlertsAlerts = False
StrMessage = "User Logged In"

[Code] ......

View 2 Replies View Related

Creating Login Via A Userform?

Dec 6, 2013

[URL]

Basically I’m trying to create a login userform that launches once the database opens.

Userform = LoginTextbox = UserformTextbox = PasswordCommand Button = UserloginCommand Button = UsercloseSheet containing passwords = Userpasswords
Usernames are stored vertically in the A column, and Passwords vertically on the B column both starting from row 1.

I’ve been using code found at [URL] but I’m struggling to make it work. Some of the variables listed below may be useless but I’m not entirely sure so I’m sceptical about removing them. !

VB:
Option Explicit
Dim ws As Worksheet
Dim Userpasswords As Worksheet

[Code]....

View 5 Replies View Related

Login To Website Using VBA Script

May 19, 2014

I'm trying to login to [URL] ...... using VBA. I cannot share login details. How it might be able to work?

View 3 Replies View Related

Create Login Screen

Mar 4, 2014

I am quite new to the excel vba. I am trying to create a login screen

So whenever i open my excel sheet, the first thing should happen is that there should be a login screen and ot should ask for password and id. Once you provide the login id and password, you would proceed to the next screen.

View 2 Replies View Related

Drop-down List At Login

Jul 16, 2008

I have an excel file where different people have to make their comments. So far I have sent out the files on email and they sent it back and then copied their comments to the original file, but from now on I would like to share the file and let them to write in their comments.

In order to make it professional I would like the file to work as following (lets suppose that I am Mr.X and I have to write my comments in row 2,6 and 9):

1. When I (Mr.X) open the excel file, there is a pop up message box with a drop down list saying: "Please select your name:"

2. In the drop down list I select my name (Mr.X) and I press OK.

3. Then I get logged in the file and I will see rows 2,6 and 9 only.

4. After making my comments I save the file and log out.

As for the example lets assume that there are 3 people who are making the comments. Mr.X /rows 2,6 and 9/, Mr.Y /rows 1,3 and 8/ and Mr.Z /rows 4,5 and 7/

View 14 Replies View Related

Login To HTTPS Server

May 2, 2013

I am looking to further improve this code by adding the functionality of logging to a secure HTTPS server using username and password.

Code:

Sub TestFileExistsandDownload()
'This code will test a web address to see if a file exists
'If the file exists, it will download the file.
' It's a mixture of code retreived from 2 sites:
' [URL]...
' [URL]....

[Code]...

View 1 Replies View Related

Track Changes Based On Login Name

Dec 21, 2006

I've been looking around for a way for Track Changes to reference the loggedin username of the workstation rather than the name in Excel registration.

I found this
Function UserNameWindows() As String
UserNameWindows = Environ("USERNAME")
End Function

: on this board and another blog.

But I don't know how to enter it to make this work. I had read you make it a new module and assign a formula, but the most I could get through was opening the VBA editor for the workbook, creating a new module, and pasting the code. Changes would still reference the Excel registration name, not the Windows' logged in username.

View 9 Replies View Related

Login Option On Workbook

May 1, 2007

if it's possible to add a login when you open a workbook and keep a log of who has logged in with the time noted......or am I being a bit optimistic?

View 9 Replies View Related

Code To Login To Webpage

Oct 14, 2009

I'm trying to use the CreateObject("MSXML2.XMLHTTP") technique to log in to my Amazon Seller Central account and extract the HTML page source of the URL. However, I simply haven't been successful with getting it to log in. I should note that I know very little about this technique, and simply copied and slightly modified the code from a website. It works when there is no log in. Here's an example of the

Dim URL As String: Dim HttpRequest As Object

URL = "https://sellercentral.amazon.com/gp/orders/fba-order-details.html?ie=UTF8&orderID=123-4940-3939039"

Set HttpRequest = CreateObject("MSXML2.XMLHTTP")

HttpRequest.Open "Get", URL, False
HttpRequest.Send

This is the code I use to get the page source when I don't need to log in. However, the URL I'm now trying to get to requires me to log in first. I've come across a couple different sites that offer the following techniques:

1) URL = "https://usernameassword@sellercentral.amazon.com............."
2) HttpRequest.Open "Post", URL, False, username, password

View 2 Replies View Related

Macro: Login To Web Query

Dec 15, 2006

So I have some data that I'd like to extract from some financial sites that I'm a member of (one in particular is investors.com). I try and pull stock info from the site, but I have to manually initiate a new web query, go to the website, login, then cancel the web query for the macro on my spreadsheet to start pulling information. What I'd like to do is have two cells referencing my user id and password, and then click a button that will goto the website from excel, login, and allow the extraction of financial info to occur.

View 6 Replies View Related

Userform To Act As A Login With A Password

Apr 12, 2007

I want the userform to display an input box asking the user to enter their 'login ID'. This has to be either "SUPERVISOR" or "STAFF".

Upon correct entry i need it to then display another input box asking for a 'password'. This needs to be "SHOES" for both logins.

If the login is not equal to SUPERVISOR or STAFF I need a message box displaying "username incorrect". and for it then to show the input box requesting the 'login ID' again.

Again if the password is not equal to "SHOES" to display a message box displaying "password incorrect" Then show the input box requesting the password.

Upon correct entry for both the username and password i would like my other userform to show. This is displayed by:

Load UserForm1
UserForm1.Show

I would like the correct 'username' to be displayed in cell "D27" on the active sheet and 'password' to be displayed in cell "F27" also on the active sheet.

If there is a way to display the password using asterix's for security that would be useful.

View 9 Replies View Related

Code To Verify Password On Login

Feb 22, 2014

I found some username and password login code that I am editing for my needs, but I am having some trouble with it. I keep getting run time error '448': Named argument not found on the following line:

MatchCase:=False, SearchFormat:=False)

[Code] .....

I have also attached my workbook.

Equipment Return Log.xlsm‎

View 2 Replies View Related

Get Data From Website That Requires Login

Jun 28, 2012

I need to get data from a website that requires to log-in, so i set this Vba, and i get an error "object dosent support this property or method"?

Sub GetTable()
Dim IEApp As Object
Dim IEDoc As Object
Dim IETable As Object
Dim clip As DataObject
Set IEApp = New InternetExplorer
IEApp.Visible = True

[code]....

View 1 Replies View Related

Get Excel To Login Automatically To Website

Apr 22, 2013

Is there any way in which I could get Excel to login automatically to this website [URL] .... for obvious reasons I cannot divulge the username or password.

I have managed to get excel to open the site.

View 5 Replies View Related

Getting Macro Program With Array Login

Aug 5, 2013

I need to write one Macro program for below logic.

A
B
C

123
123
‘TRUE’

123
234
‘TRUE’

[code]......

View 3 Replies View Related

Creating A Login System For Users

Dec 7, 2006

I have a worksheet that is going to be used my approx. 10 people at my company. I want to give access to certain menus to a few people and other menus to others. I have 2 custom menus. One is for each group, but I don't want to allow access to the other groups menu. Is there a way to create a way of logging in via username and password so that excel can display only the correct set of menus depending on who is using the sheet at the time? I think there is a way that excel can recognize the windows login and password for each person and maybe I can use that? If so, how do I then set it up to display only the correct menus to certain users?

View 9 Replies View Related

Userform To Act As A Login With A Password To Use The Spreadsheet

Apr 12, 2007

I have come up with the idea to create a userform to act as a login page for my project. I have the project complete and need a way to protect it. I want the userform to display an input box asking the user to enter their 'login ID'. This has to be either "SUPERVISOR" or "STAFF". Or If I have a table of 'users' and 'passwords' in sheet (USERS) to match them against that if it is easier?

Upon correct entry i need it to then display another input box asking for a 'password'. This needs to be "SHOES" for both logins. If the login is not equal to SUPERVISOR or STAFF I need a message box displaying "username incorrect". and for it then to show the input box requesting the 'login ID' again. Again if the password is not equal to "SHOES" to display a message box displaying "password incorrect" Then show the input box requesting the password. Upon correct entry for both the username and password i would like my other userform to show. This is displayed by:

Load UserForm1
UserForm1.Show

I would like the correct 'username' to be displayed in cell "D27" on the active sheet and 'password' to be displayed in cell "F27" also on the active sheet To show who is 'Logged On'. If there is a way to display the password using asterix's for security that would be useful.

View 6 Replies View Related

Password Login To View Sheets

Mar 13, 2008

I have a workbook which, on opening, shows a logon form and depending on the username and password entered only certain sheets open - there are about 10 usernames and passwords - i have only included 2 to keep the code a bit shorter. I got the code below from here and it works perfectly but I want to make it a bit easier to add new usernames and passwords and am thinking of using a Vlookup table. The code i currently use is:

Option Explicit
Const sName1 As String = "Lisa"
Const sName2 As String = "Philip"
Const sPw1 As String = "update"

Dim sPW As String, sUser As String
Dim sMsg As String, sTitle As String, sStyle As String
Dim iCounta As Integer
Private Sub cmbValidate_Click()
sTitle = "Incorrect Password"...........

View 5 Replies View Related







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