Handle Password Input?

Jan 30, 2009

Is there a way to type in a cell and click on a Command Button instead of the Enter Key-- and then run a macro using the value that was typed into that cell? Or any other way to eliminate the need to hit Enter Key to record the user input and then hit Command Button to run the macro? I have 40+ users who login in by selecting their name from a drop down list and then entering their password in another cell. (what they input must match another cell in same row.) Attached is scaled down model of Workbook and the macro that works to login.

View 5 Replies


ADVERTISEMENT

Input Box Prompt For Password

Dec 5, 2007

How The Vba Code Used For

My Excel File Name "eai.xls" ,when I Click The File , It Open The Sheet Name "menu" With The Inputbox Prompt:="put Your Id"
When The User Put The True Id , It Will Show The Input Box Prompt:="your Password" . If The Password True Will Activate The Sheet Name "data" .and Hide All The Menu Bar.

If The Wrong Id Name Show The Msg.box "re Enter Your True Id " ,that Also For The Wrong Password In Which If User Put More Than 3 Times Wrong , Will Close The Workbook And Exit File.

The User Persons Allow 10 Person Id . Keep In The Table Of The Sheet Name " Id And Password" The Id No. Are In The A1:a10
Password No. Are In B1:b10
This Sheet Name Is Hide And Protect

View 14 Replies View Related

Password Char For An Input Box

May 11, 2007

Is it possible to set a PasswordChar for an InputBox?

Basically, I have an input box asking for an admin password to make changes, and I'd like to make it so onlookers wouldnt be able to see the password. Any suggestions on how to do this?

I could make another userform and have the textbox have a PasswordChar, but I'd rather not.

View 4 Replies View Related

Hide Password Input

Jul 12, 2007

like PHP, you can enter a box and have it so what is entered is meant to be a password, so puts stars where the text is. I would like to do something like that with VB INPUT tag:


pw = Input ("Please enter Password:")

Is there a method I can add to this to make it cover the text being typed?

View 9 Replies View Related

Mask Password Input Or Entry

Oct 31, 2006

how can i show asterixes instead of the input data as it is being typed in a cell? somewhat like a password box...

View 6 Replies View Related

Password Protection :: Asking For Password Of An Old Deleted File

May 27, 2009

When opening a new Excel file, it is asking me for a password to an old excel file that was password protected, which I have deleted from my computer. It is still asking for this password every time I open a new or existing file. When I hit cancel it lets me open the file.

View 11 Replies View Related

Forgotten Password For Password Protected Sheet

Mar 21, 2007

I have a spreadsheet, which has certain worksheets that are password protected. I need to make changes to some of the formulas, and the VBA modules, however I cannot remember the password!! Is there a way of identifying the password??

View 3 Replies View Related

Using The Fill Handle

Apr 24, 2009

How can I fill downwards the following formula?

=(SUM(B$2:B13)*0.05)*(J2/12)
=(SUM(B$2:B12)*0.05)*(J3/12)
=(SUM(B$2:B11)*0.05)*(J4/12)

View 4 Replies View Related

Append Value To Url In IE Using Window Handle?

Nov 2, 2009

I'm trying to manipulate a URL in an already opened IE browser window. In a nutshell, I need to change "http://www.excelforum.com" to "http://www.excelforum.com/this-is-the-new-part"

The code prior to this does the following:
- Opens a new instance of IE
- Enters the username and password required to get into the site
- Scrapes the source code, imports it into Excel, and parses the data
- Finds a row based on the current date and some text
- Extracts from that row a unique identifier...
- Obtains the window handle ID for the instance of IE displaying the website

Now I need to add the unique identifier to the url. I cannot open it in a new tab or instance of the browser, as it revokes back to the login screen. I was assuming that the best way to do this would be to get the window handle, then just send a "tab" to get back to the URL, and enter the new URL. If there's any other way to do this, I'm all ears. Otherwise, how can I send the keys using the window handle?

View 2 Replies View Related

Formula To Handle Data

Jan 14, 2010

Would need your expertise to advice on how to create a formula to handle the following data in order to produce the desired output below.

I have some data in Sheet 1 and the corresponding data in Sheet2. The output is in Output Sheet.

If the data in Sheet1, "Student1" match the data in Sheet2, "Student1", then it will copy all the entries for Student1 in other worksheet with the header "Student1" (Output Sheet).

The same thing goes to other Student in the list. For this sample, I only provide a short list of data in Sheet2, it can be long, more than 5 students.

Sheet1
------------
Student1 | Student2 | Student3 | Student4 | Student5

Sheet2
------------
Student2 | Student5 | Student3 | Student4 | Student1
aaa | aaa | fff | aaa | aaa
ddd | fff | ccc | ccc | bbb
eee | ccc | ccc | ddd | ccc
ccc | ddd | ddd | eee | ddd
eee | eee | eee | bbb | eee
bbb | bbb | aaa | fff | fff..................

View 5 Replies View Related

Fill Handle + Query

Sep 16, 2005

I can't seem to get the fill handle "+" sign to give the correct amounts when
I want to copy a formula down a column. It seems to skip every 2nd row with
the wrong amount or sometimes it will give a 0.00 sign.

View 9 Replies View Related

VLOOKUP Can't Handle Pictures?

Jan 12, 2014

I have this on sheet1 on B2 and B3 , where war-200 is chosen through drop down menu , while another sheet named pics has war-200 on A1 and its picture on b1 , is there a formula to throw the picture on C3 of sheet1 from table of code and pictures

Select Code

WAR - 200

View 2 Replies View Related

Handle The Enter Event

Apr 29, 2007

The code handles keydown, keypress events with no problem. Also similar change events, and probably more.

This code is at UF initialize event:

Option Explicit
Dim TextBoxes() As New Class1
Dim ComboBoxes() As New Class1

Private Sub UserForm_Initialize()
Dim TCount As Long, CCount As Long, c As Control
TCount = 0
CCount = 0
'Set TabIndexCollection = New Collection
For Each c In Me.Controls
' TabIndexCollection.Add c, CStr(c.TabIndex)
If TypeOf c Is MSForms.TextBox Then................

View 9 Replies View Related

Using Autofill Handle For Letters

Oct 10, 2007

How can i use the Autofill handle for letters?

I want to be able to do the following:

In cell A1 i type: A
In cell A2 i type: B

Then i want to use the handle to get in column A the rest like C D E....Z AA AB AC.......AZ BA BB BC etc.

View 9 Replies View Related

How To Handle #Div/0! In Select Case

Jan 31, 2008

I have below codes:

Private Sub Worksheet_Calculate()

For Each rCell In Range("D2:CU5")
Select Case rCell.Value
Case 1, 0.000000001 To 89.499999999
rCell.Interior.ColorIndex = 3
Case 2, 89.5 To 99.499999999
rCell.Interior.ColorIndex = 6
Case 3, 99.5 To 109.499999999
rCell.Interior.ColorIndex = 4
Case 4, 109.5 To 999
rCell.Interior.ColorIndex = 8
Case Else
rCell.Interior.ColorIndex = 15
End Select
Next rCell

End Sub

However if a value within the range "D2:CU5" happens to be #Div/0! (or any error value for that matter) I get a debug error message. Then the CASE ELSE formatting doesn't apply. I expect that everything else should fall under CASE ELSE. Is there a way to handle this i.e. the formatting under CASE ELSE applies?

View 9 Replies View Related

Get Handle To A Control On A Spreadsheet

Oct 13, 2009

How do I get the handle for a combobox on a spreadsheet? I have tried ChildWindowFromPoint and RealChildWindowFromPoint without any luck.

View 9 Replies View Related

Handle #N/A! In VLOOKUP Macro

Nov 7, 2006

I am doing a vlookup accross two sheets where I am adding up the first Vlookup with the second vlookup (ie vlookup sheet 1 + vlookup sheet2) and in one of the sheets the vlookup formula finds a value but in the other sheet it finds nothing. As such when the two formulas are added together it gives a value of #N/A. Since I have made a macro for this it is annoying.

The macro is as follows:

Sub Vlookup()
Dim rowc As Long
Dim i As Long

Application. ScreenUpdating = False

rowc = Application.WorksheetFunction. CountA( Range("a:a"))
For i = 2 To rowc
Cells(i, 3) = "=-VLOOKUP(RC[-2],Hksaldo!C[-2]:C[3],6,FALSE)+VLOOKUP(RC[-2],Likv!C[-2]:C[2],5,FALSE)"
Next i

End Sub

how I can get around this. Ie when I have a non applicable value i one of the Vlookup formula the formula should only look at the vlookup with a value?

View 4 Replies View Related

Use Fill Handle On Function

Jan 26, 2007

I have a function =TimeSinceIns(3) in cell K3. Where the 3 represents the row number. I would like to fill the function all the way down to cell k100. And be able to do this reguarly. Unfortunately when I use the fill handle it leaves 3 as 3 when I want it to be changing to the appropriate row no. Ie in cell k4 would be =TimeSinceIns(4) and so on.

View 3 Replies View Related

Macro - Paste Password Into Password Box

Nov 28, 2008

I am havng problems with the belwo macro code -

Range("G7").Select
Selection.Copy
Workbooks.Open Filename:= _
"Q:PublicPAYMENTS Q&RREPORTSSuspense Activity BUSINESS2008 - Suspense BUSINESS - Activity Reports2008 Avon.xls"
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
End Sub

When i open the workbook it requires me to insert a password, i tried to type this but excel will not follow keystrokes, i then inserted the password in cell G7 which i then copy and paste, which you can see the copy at the beginning of the macro.

Is there a way where you can get it to insert the password so i can open the workbook in a macro.

What im trying to do is save 26 suspense spreadsheets by just clicking on a macro.

View 9 Replies View Related

Using Auto Complete Handle (+) With Formulas

Apr 24, 2009

I have the following formula in a cell C6 : "='Data Dump'!G20". I want the adjacent cell on the right (C7) to be "='Data Dump'!G21" and C8 to be "='Data Dump'!G22" and on and on. I'm trying to use the Auto complete handle on the bottom right hand corner of the cell (which looks like a + when the cursor is over it) to drag the formula so that the "Data Dump - G" values increase as I go (g21, g22, g23 and onwards). However, rather than the numerical part of the cell incrementing, the character (letter) does so instead, so I get H20, I20, J20 and onwards.

View 2 Replies View Related

Date Series / Fill Handle

Feb 2, 2012

I would like to use the Fill Handle to create a column of dates.

The dates must be formatted like this: DD/MM/YYYY HH:MM

The Fill Handle completes the series, but not the way I want.

I want a series that changes the day only. So:

02/02/2012 09:00
03/02/2012 09:00
04/02/2012 09:00

For whatever reason, Excel currently adds a minute or two to the minutes and does not increase the date.

13/2/2012 09:20
14/2/2012 09:20
15/2/2012 09:20
13/2/2012 09:21

[Code] .......

View 7 Replies View Related

Large Function - Logic To Handle A Tie

Apr 5, 2012

I use a large function when ranking numbers in an array each month. I'm only interested in the top 5 numbers. However, there are occasions when the top 5 numbers contain a tie. How do you build into a large function, logic to handle a tie. Here's my function, which is very simple:

Code:

=LARGE(C$6:C$40,1)
=LARGE(C$6:C$40,2)
ETC.

View 1 Replies View Related

Getting Window Handle Of All Open Workbooks?

Apr 10, 2004

I am trying to get the caption that is displayed on each window of all the open workbooks. I am using the code below to loop through all the workbook windows, get their handles and finally display their respective captions on a Msgbox.I am having 2 problems:

1- The code loops only once instead of once for each open workbook !

2- The Msgbox displays an empty string instead of the workbook caption !

If I am not mistaken, problem 2 is due to the fact that the Class name"EXCEL7" used in the code refers to a worksheet and not to a workbook. The trouble is I can't figure out what a Workbook Class name is so that I can use it in the FindWindowEx Function

Code:

Private Declare Function FindWindowEx Lib "user32" Alias "FindWindowExA" _
(ByVal hWnd1 As Long, ByVal hWnd2 As Long, ByVal lpsz1 As String, ByVal lpsz2 As String) As Long[code]......

View 9 Replies View Related

Code To Handle Negative Numbers

Jan 22, 2007

The below code looks in a certain column and deletes rows based on values less than the entered value in the input window. The problem with the code below is that it does not remove rows that have negative numbers. There is the possibility of a negative number being in the column so I would like to have that removed as well.

What would the code look like to add to the current code to remove the rows that have negative numbers? -1, -2, etc.

Sub Delete_Part_Input()
Dim Qty As Integer, i As Integer, ans As Variant

Qty = Application.InputBox("What total quantities would you like to delete? Note: This is the value located in the C column.", Type:=1)
If Qty = 0 Then Exit Sub

ans = MsgBox("All totals with a quantity of " & Qty & _
" or less will be deleted." & vbCrLf & vbCrLf & _.............

View 9 Replies View Related

Error Handle Routine For Macro

Aug 16, 2007

How can I edit the following code. If the "Dload" tab is not there the code errors out. How can I make it so that if the "Dload" is not there the macro says "Dload tab missing. Do you want to check file and try again" If the user says yes. then the macro lets the user pick another file. If the user chooses No then does similar quesiton like I have here starting with

OpenA.Activate.

ChDrive "E:"
ChDir "E:2007 WorkAnalytical ReviewBalance Sheet"

View 9 Replies View Related

Pivot Table Can't Handle 64,000 Rows

Nov 4, 2008

I have 63,893 rows and 3 columns (Parents, Component and Qty) in a table. This would be typical for a Bill of Materials showing the Qty of Components in a Parent. A lot of Components are common to a mumber of Parents.

In total I have 4,259 Parents and 10,904 Components making up this 63,893 rows in my table.

The problem is that neither the Pivot function in Excel nor Access will handle it, least not the way I'm doing it - the bog standard way ! I just get the "Excel cannot complet this task with available resourses......" message.

Anyone any ideas how to get a Pivot or something resembling one so that I end up with the Components as the Row Header and the Parents as Column Headers.

I know I could go in and manipulate the data but I want to be able to create this Pivot like report every month or so without having to reinvent the wheel each time.

View 9 Replies View Related

Getting The Window Handle Of All The Open Workbooks

Apr 10, 2004

I am trying to get the caption that is displayed on each window of all the open workbooks. I am using the code below to loop through all the workbook windows, get their handles and finally display their respective captions on a Msgbox.

I am having 2 problems:

1- The code loops only once instead of once for each open workbook !
2- The Msgbox displays an empty string instead of the workbook caption !

If I am not mistaken, problem 2 is due to the fact that the Class name"EXCEL7" used in the code refers to a worksheet and not to a workbook. The trouble is I can't figure out what a Workbook Class name is so that I can use it in the FindWindowEx Function


Private Declare Function FindWindowEx Lib "user32" Alias "FindWindowExA" _
(ByVal hWnd1 As Long, ByVal hWnd2 As Long, ByVal lpsz1 As String, ByVal lpsz2 As String) As Long

Private Declare Function GetWindowText Lib "user32" Alias "GetWindowTextA" _
(ByVal hwnd As Long, ByVal lpString As String, ByVal cch As Long) As Long

Private Sub CommandButton1_Click()
**Dim BookNameLenghth As Long
**Dim strBuffer As String
**Dim bBufferSize As Long
**Dim lParent As Long
**Dim lChild As Long

View 9 Replies View Related

Handle Missing Reference Errors

Dec 2, 2008

is it possible to handle errors that do not come from the Excel application from a VBA macro?
I have a macro that calls another application (a custom developed one).
If the user interface of that application is not open, then you get a message like:

REGISTRY ERROR
"Missing the webservice name in the registry database,

If I try to use the classic

On Error Goto ErrorHandler

in this case, it won't work.

View 3 Replies View Related

Turn Off Increment With Fill Handle

May 22, 2008

When I have a text field, such as 123 Main Street, Suite 456 and I copy it down, I get

123 Main Street, Suite 456
123 Main Street, Suite 457
123 Main Street, Suite 458

What is this feature called, and how do I turn it off?

View 2 Replies View Related

Password Protect: Unlock The Worksheet, Autofilter It, Print It, Unfilter It, And Password Protect The Sheet Again?

Jan 12, 2007

I have a sheet that is password protected. I have this code attached to a command button. It will unlock the worksheet, autofilter it, print it, unfilter it, and password protect the sheet again. However it is protecting it without a password. I need to have it protected with the password so that someone will not be able to just go to tools to unprotect the sheet.

Private Sub CommandButton1_Click()
ActiveSheet.Unprotect "rainforest"
Columns("O:O").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=">0", Operator:=xlAnd
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter Field:=1
Selection.AutoFilter
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowSorting:=True, AllowFiltering:=True
End Sub

View 3 Replies View Related







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