#Excel macro button not working data validation list password#
If you are using this approach in your own workbook, you will need to modify the potential input range and you will want to change the password used to unprotect and protect the worksheet. If it was, then the worksheet is unprotected, the cell in which information was just entered is locked, and the worksheet is again protected. What it does is check to see if the input was done in the proper range of cells, in this case somewhere in the range of A1:D100. This macro assumes that the worksheet has already been protected and that all the cells where you want input to be possible are unlocked. Sheets("Sheet1").Protect password:="hello" Sheets("Sheet1").Unprotect password:="hello" Set MyRange = Intersect(Range("A1:D100"), Target) Private Sub Worksheet_Change(ByVal Target As Range) Is this because I have a created a macro-button on my worksheet Kind regards, B. On other worksheet I can click on this button. However I cannot click on the data validation button. The following macro is an example of how you can do this: In a worksheet I am trying to to create drop down lists. I tried to change the name of the cell and that doesnt work either. so you would be choosing between the two options in the first round, and then comparing two other options inthenext round and so on. There is no inherent ability in Excel to protect your input after entry, but you can create the ability through the use of a macro. Having th merged cells is the only way to make it look right. Hat if you want to allow cells to be edited, but you want them to become protected right after someone enters information in the cell? For instance, you have cells in which a user could enter information, but once entered, you don't want them to have the ability to change the information they entered. Using Macros in Excel 2010, Macros enable you to automate almost any task that you can undertake in Excel 2010. Exactly how you use this protection has been discussed in other issues of ExcelTips. Excel offers protection for your worksheets, meaning that you can protect the contents of cells so they cannot be changed.
0 kommentar(er)
