Obtaining NT Logon id to open

[Karthikeyan Devan]

Hi All,

I have users who has to pay their invoices. I have kept all in one excel.

such as, vendor name, invoice id, invoice #, requestor name, etc..

Only requestor will open this excel and will see their own pending invoices.

1). Now i want requestor to put their NT login id and passowrd to open the spreadsheet.

2). Once the requestor enter his/her NT login id and password, then only the rows which are correspoding to their names should be reflecting and other rows should be automatically hidden and no one should be able to unhide except me and my manager.

3). Requestor name will be in the column "H".

Any help on this would be really really appreciated.

 

[Trevor G]

Try this

Look to create a userform in the VBA screen which has 2 textbox, and 2 Command buttons and name them something like:

txtNTID
txtNTLogin

Create a sheet which will hold there NT ID and NT Login information


Command button can be used to check the data
Command button can be used to cancel the form

you can then set the userform to check the sheet against what they add to the textbox if they are correct they can see there data if not a message box can be added to state wrong information.