I want to administrate a short training test. The user has chooses a correct answer A-E, off a drop down menu. I want to set it up so the user can't answer multiple times until they choose the correct answer.
Have a worksheet that will be used multiple times. User will enter name and employee number only on the first instance that the worksheet is opened. Would like to protect that info automatically for further usage. Most of the worksheet is protected but some cells need to remain unlocked so the "whole" sheet protection will not work.
How do I protect only specified cells, say F3, G3, H3, I3, after the user enters data thru an input box without changing any other protected cells on the sheet?
I am working on my spreadsheet and was wondering if anyone knows if cells can be Protected or Unprotected based on the value of another cell?
Here is what I am looking for:
If cell "A16" on the "Input Sheet" equals AR then Protect Cells J16, K16, L16, M16, N16, and O16
If the value of A16 on the Input Sheet DOES NOT equal AR then leave those cells unprotected.
Has anyone ever done anything like this? On my spreadsheet it would allow the user to skip the unnecessary cells as opposed to having to Tab through them. Not a big deal but definitely would be a time saver and a lot more user friendly.
If you have any questions or concerns just let me know. I will wait to see what the Excel Guru's come up with.
All, can I protect my worksheet while at the same time allow users to unhide a specific range of cells?
I'm hiding cell range FA:FK, but based on certain conditions I want to allow the user to unhide the cells but I do not want the user to be able to unhide any other hidden ranges. if there is a way to do this without using VBA. If it cannot be done with VBA
Is it possible to click on a cell and use the cell info as the input data for a search instead of typing data into a cell for a vlookup?
For example, I have a spreadsheet with numbers corresponding to stock codes. Would it be posible to just click on the stock number to return the information on the stock (levels, sizes etc...) instead of typing the stock code in for a vlookup calculation.
I have a range of cells that I want to sum based on a range inputed by the user. The range begins with cell c27 and ends with cell au27. I want the user to be asked the beginning cell and ending cell of the range they want to sum and then output the answer.
I need help with a macro that allows users to put only numbers from a range of 0 to 100 and the only text allowed must be "NA" in an Excel sheet. I know that I can protect the cells from being erased and all but my main issue is that my users are putting all kinds of text values instead of NA or numbers above 100 making my life harder than it is.
I need to import some spreadsheets that are sent to me into a master database spreadsheet. I have attached both below. The complaintstest.xls is the master database and the other is the sheet that will be imported. What I would like to happen is when the macro is run, the user will be able to select the sheet they would like to import through a dialog box. After the sheet is selected the macro will import the cells from the selected sheet into the master database in a particular order. In the master database example on row 2 I have listed the columns from the sheet to be imported in the corresponding column on the database sheet. This will macro will be run a couple of times a week so the macro will have to find the next empty row to start the import on.
With that said, I want to put the row number of a user in (I have a few thousand on this spreadsheet, and all the = data be automatically pulled based on the row number I put in cell B1. So I'm hoping to write in cell B1 the following - "143" (without the quotes), and the remaining cells in column B automatically pull that data based on that, so it would look like the following
Row # 143 Name: =C143&" , "&D143&" "&E143
How do I write the functions to keep the columns the same, but change the row number based on the number I input?
I have a user form that has a combo box "City" two text boxes one called "Flight" and the other "Date". What I'm trying to do is to prevent the user from saving the data input from the user form if any of those three fields is left blank. The code that I have so far checks all of the required fields, if any are left blank a message notifys which field(s) is left blank and return the focus back to that field. But the rest of code also fires.
What I really need is either to stop the code if any fields are blank and return the focus back to the blank field, the user completes the field(s) and clicks the save again, or better yet, pause the code until all the required fields are completed and then complete the save. (There is actually another 200+ lines of code in this sub, but I deleted it to keep the post a little shorter.)
I was wondering how you can protect a formula but still allow editing in the cell. Right now I have certain columns locked while allowing others to be edited. I have a formula in one column that needs to be edited if need be but if they make a mistake and hit delete then my formula disappears and it throws the whole sheet off. Is there a way to protect your formula maybe by putting it in a different cell that can be locked and referencing the cell where they can input?
I have a macro that transfer data from one sheet to another (I have sheets called Form and Sent). Basically, the users enters data in the Form Sheet. After they're done, the data gets transferred to the Sent Sheet. I don't want users to be able to modify the data in the Sent sheet. I just want them to see the records. Also, i want the sheet protected from having users manually inputting datas. I can't accomplish this when I protect the sheet, since it is giving me an error while running the macro to transfer data. Is there a workaround?
I have coded a user form to automatically unprotect a sheet, then protect it with a password after data is entered from the User Form. Works great. However, after it is protected through the User Form script, I cannot unprotect the sheet to edit it. It will not recognize that it is the correct password, although it is.
Private Sub cmdOK_Click() Dim NextRow As Long NextRow = Application.WorksheetFunction.CountA(Range("b:b")) + 2 Cells(NextRow, 2) = txtAddProvider.Text ActiveSheet.Unprotect Password = "stats@fwh" Range("B3:B21").Select Selection.AutoFilter Selection.AutoFilter ActiveWorkbook.Worksheets("Lists").AutoFilter.Sort.SortFields.Clear ActiveWorkbook.Worksheets("Lists").AutoFilter.Sort.SortFields.Add Key:=Range( _ "B3:B21"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With ActiveWorkbook.Worksheets("Lists").AutoFilter.Sort .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With ActiveSheet.Protect Password = "stats@fwh" End Sub
Copy & paste (ctrl c & ctrl v) is very useful, but it will change the format of the cell. To avoid that it is possible use paste special (value). Is possible to protect the spreadsheet so only paste special (value) is permitted?
I am making a database system that tracks student activity in my schools lab for people taking foreign language courses. I'm trying to make it so students must use the userform to manage they're checking in and out, and not be able to have any direct access to the Spreadsheet itself. Also, it would be nice if the whole Spreadsheet was hidden, invisible, and only the user forms could be seen.
I have to enter info daily in column H. What I wanted to do is as I finish entering info in cell H3, infomation in row 2(cell A2:E2) is copied and pasted down to row 3 (A3:E3) and will continue about 100 rows down daily.
I need to create a simple stopwatch program to store the times and write details concerning each time. I got the stopwatch to work, but everytime i try to enter a cell to write in information(while the stopwatch is counting up), the stopwatch stops counting.
Is there any way to enter data while the stopwatch/macro is running?