textbox change event sheet reference will not work if another workbook open

[nigelog]

I have a research database where the code below will react to a typed reference and return instances from the database. It all works well. My problem is that it will not function if another workbook is open. Can I force it to read the "ewc codes" sheet.

Failing that I will have to look into the workbook opening in its own instance of excel as it is very handy to have open when using other workbooks.

Any help[ appreciated

I can attach workbook if required

Please Login or Register  to view this content.

[BellyGas]

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[nigelog]

thankyou for an efficient fix. Sorted now