Good afternoon,
English is not my native language but I'll do the best I can to describe my situation in english (sorry about some mistakes).
So, I have a Worksheet I'd like to protect that contains some ActiveX ComboBoxes. Taking one of them as example, because the others work the same way, the ComboBox1 is linked to a cell in the same sheet and the ComboBox1 list is bound to a database in another sheet that works only adding new lines. Based on the result of the linked cell of the ComboBox1, there are two other cells with the VLOOKUP function. Although this sheet with the ComboBoxes is going to be used by a lot of people, only the authorized ones, who have the password, should edit the equations and the Macros. Currently I'm using in my Macros the following code to permit the Macro to work normally and still prevent human editions: "nameoftheSheets".Unprotect "password" and "nameoftheSheets".Protect "password". The problem is, I can't do this with the ComboBoxes, they can't edit locked cells but I need the cells they edit to be blocked!
I'll be extremely grateful if someone could help me!
English is not my native language but I'll do the best I can to describe my situation in english (sorry about some mistakes).
So, I have a Worksheet I'd like to protect that contains some ActiveX ComboBoxes. Taking one of them as example, because the others work the same way, the ComboBox1 is linked to a cell in the same sheet and the ComboBox1 list is bound to a database in another sheet that works only adding new lines. Based on the result of the linked cell of the ComboBox1, there are two other cells with the VLOOKUP function. Although this sheet with the ComboBoxes is going to be used by a lot of people, only the authorized ones, who have the password, should edit the equations and the Macros. Currently I'm using in my Macros the following code to permit the Macro to work normally and still prevent human editions: "nameoftheSheets".Unprotect "password" and "nameoftheSheets".Protect "password". The problem is, I can't do this with the ComboBoxes, they can't edit locked cells but I need the cells they edit to be blocked!
I'll be extremely grateful if someone could help me!
