Fill unprotected cell inbetween protected section using excel vba

[aashrithh]

I need to fill the field next to 'Enter your TIN'(Highlighted in image) and Enter Mon...

Following is the code I had written for entering the TIN...

' Fill out tin no. - not working
Dim tinNo
tinNo = InputBox("What is your TIN")
range("B1").Value = tinNo

When I use the above code to fill the value, it is giving me a run time error '1004'...The cell or chart you are trying to change is on a protected cell...I don't have the password to unprotect the excel

Manually this filed can be filled so I believe I am doing something wrong in the code.

The file(VAT_SL_EXL_XML.xls) I am using is available @ https://drive.google.com/folderview?id=0Bw97zVRZuJdYXzhnd0dkN2pFZUE&usp=sharing

If image attached is not visible, I have uploaded the same for reference the URL above.

Any help you could provide is much appreciated.

 

[Snakehips]

aashrithh,

Welcome to MrExcel.

Judging by the image, cell B1 is covered by a TextBox ????

If so then cell B1 behind the TextBox is locked and you will need to code to populate the text box.

 

[aashrithh]

aashrithh,

Welcome to MrExcel.

Judging by the image, cell B1 is covered by a TextBox ????

If so then cell B1 behind the TextBox is locked and you will need to code to populate the text box.

Dear Snakehips,

Thanks for the info.
I will try to populate the text box and update the tread with the results.

 

[aashrithh]

Dear Snakehips,

Got it to work ...Thanks a lot again for nudging me in the right direction

Cheers,
Aashrith