over riding data validation in excel

Hello
I have this excel sheet set to accept certain values only through the data validation field set to accpt only these values only
1, 20, 35

however i seem to be able to set the values through VB by unprotecting the sheet.

when i go back to excel, the value say 60.001 is there, however, data validation still says i can only have 1,20 or 35

is my vaue 60.001 written to the cell valid or does it have limitations?

Can you post some code?

Code:

---

XLsheet(FOO).Worksheets("budget").Cells(5, 2) = foo1

---

i am trying to write a value to cell(5,2) determined by foo1,
however cell(5,2) has been data validated to accept two values 20 and 35,

if i directly try to write values to it using by opening the excel sheet, it throws up the error

the value you have entered is not valid. a user has restricted values that can be entered in to this cell, but if i use the above code, (i unprotect the sheet before using the above code and then protect it soon after), i can input any value i want to.

i was wondering that the value i input into the cell, does it have any restrictions