Opening My Spreadsheet Which Will Only Open If The Correct Answer/ Password Is Typed
Apr 22, 2009
upon opening my spreadsheet which will only open if the correct answer/ password is typed.
I’d need to store the questions, passwords/ answers somewhere for VB to look up I guess??
Capital of England – London
Capital of France – Paris
Capital of Italy – Rome
Etc etc
And then I need coding which will open one of the random questions, which will only grant access to the spreadsheet if the correct answer is typed.
View 9 Replies
ADVERTISEMENT
May 29, 2008
have a password protected spreadsheet with a userform for people to enter data. This allows them to enter data, but stops them from editing or deleteing data once entered.
When the spreadsheet is opened, it asks for a password to unlock it. Hitting cancel allows the user to continue and the userform pops up for the user to enter data. I would like to disable the initial password prompt when the file is opened to avoid confusion on the users part.
View 9 Replies
View Related
Apr 19, 2006
I am just wondering if it is possible to insert a module or a code such that it is user specific.
In detail, there are two types of users: Administrator and User.
If it were administrator, it should ask for a password. If user, it should give the read-only or a protected form of the spreadsheet.
I just need the workbook to pop-up with a msgbox of administrator/user with a radio button or a select button. If administrator, it should ask for a password. Also, disabling the macros should not open the spreadsheet as making this would lead to nothing.
View 3 Replies
View Related
Jun 18, 2013
I inherited a spreadsheet from a recently let go co-worker. This spreadsheet has a lot of important financial data on it, so I really need to get into the spreadsheet. we contacted the former employee and he said he forgot the password. Is there any work around to get into the sheet?
View 2 Replies
View Related
Mar 11, 2013
I am using this formula for long now
=SUMPRODUCT(('[Diesel Statement.xlsx]Nov 12'!$C$2:$C$251=$H$1)*'[Diesel Statement.xlsx]Nov 12'!$G$2:$G$251)
every month i just add a new sheet and change the month name in the formula to that eg
I changed it to
=SUMPRODUCT(('[Diesel Statement.xlsx]Dec 12'!$C$2:$C$251=$H$1)*'[Diesel Statement.xlsx]Dec 12'!$G$2:$G$251)
but now it is not calculating the answer is coming as #value!.
Then I tried to add up by
=VLOOKUP($H$1,'[Diesel Statement.xlsx]Dec 12'!$C$2:$G$215,5,TRUE)
but it does not add all the entries only one entry is shown.
I want the total of the column G. looking up for values in C = H1 value
View 7 Replies
View Related
Feb 20, 2009
I have a workbook with calculations for a sale less the assorted fees and at the end giving the final amount from a sale.
I have noticed that some of the rows are not giving the correct amount in them.
In other words the addition of some columns in that row are not adding up correctly. It is only off by 1 cent (either over or under), but I can't figure out why.
I have the feeling that I am going to want to kick myself when someone explains this to me (I just know that I know the answer but for the life of me I can't right now).
View 2 Replies
View Related
Nov 26, 2006
How can I get this to read each, (if (and statement) and give the correct answer. And not give me the 1st underlined statement answer in cell D10. If that also equals true.
But if any other cells G11 thru G14 equals OUT. It still will give the 1st statement.
I need the answer to be the only one of them correctly that’s equal true.
I know that the 1st underlined statement = true. Because G15= OUT .....
View 9 Replies
View Related
Apr 6, 2008
I have 2 worksheets (worksheet 2 is Slicing and Worksheet 1 is Production).
Production worksheet D6 has a dropdown box for, 1, 2, 3, 4, 5, 6, 7, 1.1, 2.2, 3.3, 4.4, 5.5, 6.6 and 7.7.
In the Production worksheet, I have in cell E6 =IF(D6=1,"ONE",IF(D6=2,"TWO",IF(D6=3,"THREE",IF(D6=4,"FOUR",IF(D6=5,"FIVE",IF(D6=6,"SIX",IF(D6=7,"SEVEN")))))))
In the Production worksheet, I have in cell F6 =IF(D6=1.1,"ONE",IF(D6=2.2,"TWO",IF(D6=3.3,"THREE",IF(D6=4.4,"FOUR",IF(D6=5.5,"FIVE",IF(D6=6.6,"SIX",IF(D6=7.7,"SEVEN")))))))
How do I show in Slicing worksheet cell B6, either 'ONE', 'TWO', 'THREE', 'FOUR', 'FIVE', 'SIX', 'SEVEN' as i have the formula =PRODUCTION!E6&PRODUCTION!F6 and the cell shows '
View 9 Replies
View Related
Nov 6, 2011
I created an UserForm that looks for Student Name his/her Conferenece Date through a VLookup.
The following is my code:
Private Sub cmdFind_Click()
With frmConference
.txtTranslator.Value = Application.WorksheetFunction.VLookup(txtStudentName.Value, Sheets("SPANISH").Range("A2:F113"), 6, 0)
.txtDate.Value = Application.WorksheetFunction.VLookup(txtStudentName.Value, Sheets("SPANISH").Range("A2:F113"), 5, 0)
.txtTime.Value = Application.WorksheetFunction.VLookup(txtStudentName.Value, Sheets("SPANISH").Range("A2:F113"), 4, 0)
End With
End Sub
The txtTranslator and txtTime works correctly, however txtDate give me a number '40850' not a Date?
How can I change this number for the actual Date?
View 9 Replies
View Related
Mar 23, 2014
I have a set of 4 multiple choice answers B,C,D,E column "F" lists a # 1-4 which lets you know which column letter (b,c,d,e) the correct answer is in. I want to set up a formula that will copy the contents of the correct answer (based on that # identifier) and copy it into column "A" which is currently blank.
View 7 Replies
View Related
Mar 23, 2014
Here's an example of what i want to do
A_________ B Frank Sinatra C Sammy Davis D Dean Martin E Joey Bishop F 3
I want to put "D"'s value 'Dean Martin' in column A - i know it belongs in A because the "3" in column F indicates its the 3rd answer listed i.e Dean Martin. This format would be the same where there are 4 possible answers on the column to the right dictates which answer is correct.
View 2 Replies
View Related
Nov 16, 2006
I am running a small segment of code in which the user is taken to a specific directory to choose the correct file.
ChDir "\Intranetuserscsandsads"
strInventoryOH = Application. GetOpenFilename
The dialogue box is not opening to the correct directory. I believe there are no permission issues as I have full access to this directory.
View 4 Replies
View Related
Oct 14, 2009
i just wanted to know if we can open a pop up which will give us answers. i have attached a example work sheet of what i require
View 3 Replies
View Related
Jan 11, 2010
I have a few 2007 workbooks that are set up to track and compare individual budgets over time. The majority of the cells are referencing workbooks that have yet to be created.
On opening these workbooks the users are confronted with an informational window informing them that "This workbook contains one or more links that cannot be updated", to which they are instructed to choose "Continue". Is there code I can add to these workbooks that would automatically choose "Continue" once a user enables the security warning for Automatic updates of links? I believe this would be the same as an On Open event.
View 7 Replies
View Related
Jun 11, 2009
I would like to create a command button that is available on my worksheet at all times. When clicked the user would be prompted for a password and then if correct a macro would run. If the password is incorrect then the user would receive an error message "You do not have access to run this maco" and he could go back to entering his values.
View 9 Replies
View Related
Nov 19, 2006
protect all the sheets. I would want the password box to popup whenever, the excel file is opened unless the proper password is entered the sheets file should remain deactivated and when the password is entered it should be displayed as "*".
View 2 Replies
View Related
Oct 4, 2007
I've looked through this wonderful sight and haven't found one close to my project. I am a bit rusty on VB programming. I am working on workbook that contains multiple worksheets. Each worksheet is hidden and is accessible with a login and password so that only a specific user can access. My question is: How do I modify this so that the manager can open the workbook and view ALL worksheets without having to enter the login name and password for all of his users? Any help would be great. Thank you!!
Below is what I have so far: ....
View 9 Replies
View Related
Jun 5, 2009
attached is a sample schedule, there is conditional formatting in all of the cells (see graphic) such that if the cells to the left are the same value, then the cell is turned white, and a border is removed.
This gives the appearance of a 'block of time' while which cleans up the appearance of the spreadsheet.
the problem i have is that when we scroll to the RIGHT, we lose track of the 'left most' cell...which is black of course, the similar ones to the right are intentionally whitened out.
a perceived solution would be to change the conditional formatting of the column (actually only the cells in the column we care about) when it is NEXT to the vertical freeze pane so that it appears not in white, but in black font, etc.
the TRICKY part is that we will obviously need to go back and forth, so the columns will need to change formatting often.
or
when the column number (or letter) next to the freeze pane changes, change the formatting to certain cells in that column to an alternate version; and change the formatting of all other certain cells within other columns to original formatting[
View 9 Replies
View Related
Nov 1, 2009
I have an Excel 2007 workbook which has five sheets in. I just wondered whether it is possible to hide all five of them when the workbook is first opened. Also I would like the user to be asked for a password when they wish to unhide a sheet, with the password being different for each of the sheets.
Is there also a way to do this which won't be affected by Excel disabling all Macros when the application initially opens.
View 6 Replies
View Related
Jan 9, 2014
Any way to automatically update my spreadsheet align all of the cells in the correct row/column.
Attached is a sample sheet. Columns A-D show how they originally look. Columns F-I show how I would like them to appear.
SAMPLE.xlsx‎
View 5 Replies
View Related
Jul 8, 2006
I have Monthly sales sheets that import my cash register data into them. I wanted to set them up to do everything without being there. So I have my task manager open excel at 9:30pm everyday and it runs the macro to import the data into the correct day of the month. Here is the workbook
open macro-
Private Sub Workbook_Open()
Dim dTime As Date
dTime = Time
If dTime >= TimeValue("9:30 PM") And _
dTime < TimeValue("9:40 PM") Then
ImportData
End If
End Sub
This is in my July spreadsheet only. So is there a way to make it know which month spreadsheet to open on the 1st of the month? So come August 1st it will automatically open the August workbook and input the data for the first day? By using the date?
View 9 Replies
View Related
Oct 27, 2009
I have a spreadsheet that on open needs to open a 2nd spreadsheet minimised and delete 2 named sheets in the 2nd spreadsheet.
On close of the first spreadsheet it should then copy 2 sheets with the same name from itself into the 2nd spreadsheet.
This is to start a spreadsheet that will track project risks and issues that I will post further details for as other functions are required.
View 9 Replies
View Related
Mar 22, 2013
Is it possible to open an OpenOffice spreadsheet in Excel while keeping all formulas?
At the minute when I try this, Excel just opens the spreadsheet with the values of each cell from OpenOffice (the results of the formulas) and not the actual formulas themselves.
View 1 Replies
View Related
May 15, 2014
I am working on a personal macro that is lauched from a file that is produced on a weekly basis resulting in a filename that changes every week due to a date range that is in the file name (ex. Weekly Accounting 04_16_14 to 04_22_14.xlsx), for this example I will call this "Spreadsheet A". When working with this spreadsheet I open another spreadsheet ("Spreadsheet B") to retreive data and I then need to go back to Spreadsheet A again to paste this data. The problem I have is I don't know how to go back to Spreadsheet A since the name changes each week and I cannot hard code the name into the coding. I usually use Windows("Random Spreadsheet.xlsx").Activate to go between spreadsheets, but in this case I cannot.
Is there something that will allow me to return to Spreadsheet A no matter what it is named?
View 3 Replies
View Related
May 16, 2007
I have a 30 in monitor (I know I'm lucky!) but when I open a new spreadsheet it opens all the way across the screen 100 columns and 100 rows. How can I change the size when it opens?
View 9 Replies
View Related
Dec 20, 2006
I was wondering if you can make a popup open when a user opens a spreadsheet. I have some templates i made and users continue to make the same mistakes. I was hoping to add a form/pop so when the file was opened a popup would come up with reminders. Once they press ok they can proceed.
View 3 Replies
View Related
Jun 19, 2007
I currently have a spreadsheet that my deparment use at work. Its just a full time equivallent sheet, nothing fancy. However I added code onto it to prevent users opening it as I was updating it.
However I went to open it and It wouldnt open. It wouldn't recognise me as being the exception. Its just a code on the workbook open that says if user is "slb090" (which is me) then do nothing, else msgbox and just a quickie sayign come back later".
I have attached the spreadsheet, in the hope someone can open this for me and remove the message so I can open it!
View 3 Replies
View Related
Nov 30, 2009
I need to make my spreadsheet require a password to open. How do I do this?
View 2 Replies
View Related
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
Aug 23, 2013
I add data validation into 4 columns and when i re-open the spread sheet after saving it, it clears all validation.
Although it clears the validation, the place where it gets the data from is still there. i have also unfroze panes and is still clearing data validation
Attached is the spread sheet. The data validation is in columns A, G, H and I on the 'unsourced' page and is getting the data frfom the 'Sheet1' Page.
View 2 Replies
View Related
