|Sorry about not adding pre code...I will make sure I do from now on. I protect the sheet by going to Tools, Protection, Protect sheet and use a simple password right now. |
I have unlocked the cells that I need to work. Everything works fine except I get a runtime error on the line:
.Add Type:=xlValidateList, Formula1:="Ink-1, Ink-1.5, Ink-2, InLay-1,InLay-1.5,InLay-2"
However, if I do add code to unprotect the code and reprotect the code before and after the line everything works fine. However, if I use a password. I am prompted for the password before the code is executed.
I don't want this as other people outside of where I am will be using the spreadsheet.
Any ideas as to what I need to do?