Data Entry Form With Password Protection

Jun 28, 2007

I making a data entry form that sereval employees will be using. But what I need is data quality protection. My idea is to have a userform with a combo box. The employees would select there name from the combo box and then enter there personal password to get access to the data entry information, which will appear if the password is correct but kept hidden if password is incorrect. I have a example.xls without any code contain in it.

View 2 Replies


ADVERTISEMENT

Importing Data From A Webpage With Password Protection

Jul 31, 2005

I am trying to import data from a website protected by ID and password. I do have the login ID and Password to login to the website.

I am importing data from the website to my excel sheet to track some shipping informations. I do have the 'Import to Excel' option but I would rather open the
spreadsheet and click Refresh Data and have all the Data imported with click of a button.

I have already tried to use Import External Data but it is not working.

View 9 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

Create A Form With Password Protected Data?

Jun 6, 2014

I want to create a simple form for employees to enter their number of hours worked for the day. Driver name, Start Time, Finish Time and date. I need this information to populate an excel spreadsheet but I don't want the employees to be able to view the data that is being put in. Also possibly throw an error if the same employee accidentally enters their information twice.

View 1 Replies View Related

Creating A Data Entry Form

Feb 6, 2009

I know this problem could be easily solved with the use of access. Unfortunatly I can only use excel. I am creating a uniform stock database. I a trying to create a user friendly face sheet, so that the operator does not have to have any knowledge of excel to use it. My question is to do with a data entry form. Sheet 2 of my spreadsheet has a list of all uniform in stock. At the moment it has two coloumns, "uniform type" and "uniform size". Is it possible to create a form on sheet 1 (the user interface) where a user could imput the type and size of an article of uniform that had just come in, and have it automatically added ot sheet 2?

View 4 Replies View Related

Data Entry And Editing Using A Form

Apr 12, 2006

I am trying to figure out how to enter and edit data using a form for stock traceability.

I have created the form with the headings etc and everything works well at data entry.
However, I am trying to create a search and edit form that searches and edits existing entries.
A third form displays the data in form format when the user types in the appropriate ID.

View 9 Replies View Related

Code Data Entry Form

Oct 10, 2007

i have some data and i want search a record by two fields ("hsc and section") with in my data and i want to edit the remaining fields.

the fields of record are "hsc, section, amt, bcrc, date, prno"

View 6 Replies View Related

Password Protection

Aug 28, 2007

I use the following piece of code to show/hide certain worksheets in a workbook. To access the hidden sheets, a command button runs the code. It works very well, except that the password is openly displayed in the message box (as opposed to returning asterisks for the typed characters).

Sub togglesheets()
Dim Ws As Worksheet
Dim strPassword As String
strPassword = InputBox("Enter Password")
If strPassword "Password" Then MsgBox "Wrong Password": Exit Sub
Application.ScreenUpdating = False
For Each Ws In ActiveWorkbook.Worksheets
If Ws.Name = "Apr-Sep" And Ws.Visible = xlSheetVisible Then
Ws.Visible = xlSheetVeryHidden

ElseIf Ws.Name = "Apr-Sep" And Ws.Visible = xlSheetVeryHidden Then
Ws.Visible = xlSheetVisible
End If..............

View 9 Replies View Related

Press Button To Open Form For Data Entry And Then Send Matching Data To Another Sheet

May 5, 2009

Now that the calculations are working, with the press of a button, I need to be able to select a range of dates and copy all lines within the range to a seperate sheet with the desired name under the same headings they currently reside under. I have included some modified code that is being used in another spreadsheet that was created for me, but I do not pretent to understand all of it and I no longer work with the creator of the spreadsheet. How do I use a button to open the form for date selections and entering the name of the new sheet, and then use the start button on the form to begin the matching and copying to a new sheet? If there is an easier way I am all for that too.

View 14 Replies View Related

Create A Custom Data Entry Form

Jan 30, 2008

I am having trouble creating a custom data entry form in excel. What steps would I need to take..

Attached is a example of the data, the Headers are in bold, the highlighted columns are to be drop boxes.

View 11 Replies View Related

Creating A Form Style Data Entry

Jan 21, 2010

I'm wanting to create a simple form type interface for the viewing and changing of data one record at a time. What I'd like is on sheet one, and simple portait form to display

First Name
Surname
House Name
Address Line 1
Address Line 2
Town
County

on sheet two each column will be one of the above fields and each row will be a new record. Is there a way to do this in excel? Im trying to create a simple user experience that hide the rows & colums.

View 2 Replies View Related

How To Validate Time In Data Entry Form

Apr 12, 2012

I'm making a data entry form for a user, and one of the fields is in a time format (mm:ss). Is there any way that I can validate that field in "cmdOK_Click()" so that when the user clicks "ok" on the data entry form, if they haven't entered a date a msgbox comes up.

I tried IsNumeric with an If function but to no prevail.

View 4 Replies View Related

Customer Service Data Entry Form

May 8, 2009

Have a small data base with customer details and comments. I would like a form to sit over that so that people on phones can enter customer # and check info and add further comments etc. for a specific customer. Before I try and design a form is there any templates for this type of thing. Have done a Google and Ozgrid search, but I maybe asking the incorrect names for the procedure.

View 2 Replies View Related

Multiple User Data Entry Form

Jun 28, 2007

Basically at the moment our static data group use a generic sheet which lists all possible field variables. However, what I want to do is design something which only shows the fields that need to be filled out (ie if the field is shown it needs to be input).

Once the form is filled out it will get saved and sent via email, where it is then printed out and input by our data group. One way I thought about approaching this was to have 18 sheets which are hidden, and which are then selected when a report type is filled out. The other way would be to have IF statements but I think that would get complicated on the one sheet. Just really looking at ideas at this stage.... For example there are 30 fields on the sheet that we use now, but some reports may only need 5 of these fields - I therefore need to "hide" the remaining 25...

View 6 Replies View Related

Workbook Password Protection

Jun 5, 2014

I am trying to protect my file with a password which does not contain capital letters and contains less than 12 characters.

How can I do that?

View 4 Replies View Related

Protection Password Memory

Jan 27, 2010

I have tried Tools/Options/Security Password to modify, but it can still be saved as a copy to the network which becomes very confusing to many. If I use Tools/Potect Sheet, I need to re-enter the password for all sheets twice. I am trying have it so that everyone is read only, select people can edit (with same password). Password protect all sheets and the workbook with the same password everytime when the workbook is closed

Basically 2 questions

1) Is there a way of remembering a password so that when the workbook is closed it and all sheets are automatically protected with the same password every time

2) Is it possible to have it not copied unless it is opened by an editor

View 2 Replies View Related

Password Protection Not Working

May 29, 2009

I have a macro that needs to unprotect the sheet before it does what it needs to do. The sheet has a password (i.e. it is not just protected). the macro runs fine but when I go back to the sheet and try to unprotect it, no password is required. simply clicking on Unprotect works and I am nopt prompted for the password in the macro.

I realise that they are not the most secure things anyway but the people who are going to using this will mess around enough to try and unprotect the sheet but if they were to be promted for the password they would stop looking.

View 3 Replies View Related

How Safe Is Password Protection

Apr 13, 2012

I want to password protect a workbook but have seen softwares that claim to crack any password.

how safe is my book if I choose a really safe password with upper and lower case alpha numeric characters?

View 4 Replies View Related

Cannot Change Protection Password

Jul 19, 2014

I have a spreadsheet that was given to me, which I used as a template. It already had password protection in it for each worksheet, and the macros are also written to unprotect before performing the actions, the re-protect at the end. Everything works fine except I cannot change the password. The thing is is that the password in the macro code is not the same as the actual password which you have to type in when unprotecting the worksheets.

For example the password in the code is "IPP" and the password you have to actually enter into the unprotect sheet box is "AAAABBBABBB&", yet all the macros still work like this. When I attempt to unprotect the sheet (with the AAAA... code) and re-write the password codes in the macros to say "###" then re-protect the sheet with the new password and run the macros it'll work fine, but when I save and close and then re-open the password required to unprotect the sheet reverts back to the "AAAABBB...." and then the macros stop working because the passwords don't match (even though they didn't match before!!!)

There is no encryption password or workbook password as far as I can tell, only the worksheet protection. Why cannot I no get the password changed?

View 6 Replies View Related

Auto_open And Password Protection

May 3, 2007

I have an auto_open module that runs a couple of other small sub routines, the query I have is it possible to hide the active window from a sub?

Because it does not seem to work for me, I can step through (F8) but when I open the workbook it just flikers but does not hide it's self.

I want to hide the work book as there is nothing that the users need to see, it just has VBA code to prcess data. There is a menu item created on the command bar so the user can run the code.

I have a pasword on the VBA code would this cause issues?

Sub Auto_Open()
my_auto_open
Add_Workbook_Menu_And_Items
End Sub
Sub my_auto_open()
Dim w As Window
For Each w In Workbooks("Star_Plus_Hindi_MKII.xls").Windows
w.Visible = False
Next
End Sub

View 9 Replies View Related

Password Protection On Tabs

Aug 2, 2007

I have 1 workbook with 11 worksheets.

Is there a way users can be prompted for a password when a tab is clicked? if wrong or no password is entered, then show sheet 1 only.
1 main sheet, and 10 sub sheets. Any of the 10 tabs that get clicked need to be prompted for a password, each different.

View 9 Replies View Related

Password Protection Certain Worksheets

Aug 28, 2007

I use the following piece of code to show/hide certain worksheets in a workbook. To access the hidden sheets, a command button runs the code. It works very well, except that the password is openly displayed in the message box (as opposed to returning asterisks for the typed characters).
Is there a way of achieving this?

Sub togglesheets()
'This asks for a password before show / hide data sheets will work

Dim Ws As Worksheet
Dim strPassword As String
strPassword = InputBox("Enter Password")
If strPassword "Password" Then MsgBox "Wrong Password": Exit Sub

'This will toggle show / hide the data sheets
Application.ScreenUpdating = False
For Each Ws In ActiveWorkbook.Worksheets
If Ws.Name = "Apr-Sep" And Ws.Visible = xlSheetVisible Then
Ws.Visible = xlSheetVeryHidden

ElseIf Ws.Name = "Apr-Sep" And Ws.Visible = xlSheetVeryHidden Then
Ws.Visible = xlSheetVisible
End If

If Ws.Name = "Oct-Mar" And Ws.Visible = xlSheetVisible Then
Ws.Visible = xlSheetVeryHidden..........

View 9 Replies View Related

Spreadsheet Password Protection

Jul 24, 2008

I have a payroll spreadsheet that is going to be placed on our network server. My boss wants me to have this spreadsheet to be protected so that one person can get in, add hours and commission, and save it up on the server. Then another person can go in to that spreadsheet, open it up to get the info and use it to cut the checks. What my problem is that the person who is making the changes does not need to see the pay rate or the total dollar amount columns, but the person who gets the data out does. Neither one of these people really know how to hide and unhide columns in Excel, so I need it to have when one password opens it, the pay rate and total pay columns are hidden, but the other password will show those columns.

View 9 Replies View Related

Basic Password Protection

Oct 25, 2009

I want to be able to put password protection on a button in a spreadsheet. It doesn't need to be secure, as it's just to prevent accidental changes by 4 year olds.

My plan was to store the password value on a hidden worksheet, as I don't think there's a way to retain the value of a VBA variable when a workbook is closed. Is there a neater way to do it?

View 9 Replies View Related

Password Protection & Distribute

Dec 15, 2009

Is there a tool that can make an Excel application behave like a “real” software? Meaning, the user will still be able to do what I planned for him to do with the file, BUT it will be very difficult for the more-than-average user to “crack” any password protections I have applied to the file? (Something like an MDE file in Access, perhaps?) The reason I am asking is because I have invested a lot of time and efforts into creating an application that I wish to sell to some of my clients, and don’t want them to easily find their way into the formulas and macros I have placed in the file.

The protection tool does not have to be an Excel tool, necessarily, but it should not require any programming skills (because I don’t have them. If there isn’t such a tool? My application contains User Forms (for input), a Database (with Auto Filters and formulas) and some Pivot Table reports. BTW, my application was created in Excel 2003 but should also be used by users with Excel 2007.

View 2 Replies View Related

Password Protection A Sheet

Jun 29, 2006

Is there a way to password protect a sheet so that you have to enter a password just to access it. I dont want most users to be even able to view one sheet unless they have the password.

View 2 Replies View Related

Password Protection In Userform

Jul 20, 2006

See the attachment. Once you enable it. A userform will ask you for a password. Enter "aes" that will let you in.

My question is, when I enter the wrong password the first time, a userform popsup and asks for the correct the password. once I do place the correct password in the 2nd attempt. The file gets deleted!

It is not suppose to happen. I understand if I entered the password wrong twice the deleteing should take place.

View 9 Replies View Related

Worksheet Protection With Password

Jan 13, 2007

I have a workbook where I need to protect the sheets with a password. However, for certain macros contained in the workbook to run the sheets need to be unprotected. I know the code to unprotect the sheet but the password is required. I do not want other users to know this password.

What I need is the code to protect a worksheet with a password. Then, when a macro runs, to unprotect without user having to enter the password and reprotect with the original password when the macro has completed its run. note: I am NOT looking for any form of password breaking code!!

View 9 Replies View Related

Bypassing Password Protection

Jan 27, 2007

The spreadsheet basically copies data by looking in all workbooks in different folders (27 in total) and copies the data across. The only problem is that it keeps asking for the password on all of the spreadsheets when it is opening up the files (all have the same password) - how do I get the code to "know" the code and bypass asking for it?

Function LastRow(sh As Worksheet)
On Error Resume Next
LastRow = sh. Cells. Find(What:="*", _
After:=sh.Range("A1"), _
Lookat:=xlPart, _
LookIn:=xlFormulas, _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Row
On Error Goto 0
End Function

View 7 Replies View Related

Password Protection Through A Sheet

May 14, 2007

I got this form RoyUK and was wondering if anyone know why it comes up with a debug here

Option Explicit
Dim sPw As String
Dim i As Long
Dim r As Long
Dim iChk As Integer

For Each rCl In .Range(Cells(r, 3), Cells(r, Columns.Count).End(xlToLeft))

View 9 Replies View Related







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