Keep loosing Sheet reference in my Data valildation list

[Frank.Egelund.Jensen]

Hei

I have a data entry sheet, where the customer name are validated in the customer list on a different sheet.

The file keep loosing the sheet name in the validation address.

This has happend several times, and this confuse the users.

Is this a known bug and are there a way to avoid this problem ?

Regards
Frank

 

[Gingertrees]

Kindly post your code that is validating your customer names.

 

[Frank.Egelund.Jensen]

Hey - there are macroes doing other things, but the problem is the standard Data validation list, which is on a different sheet. There no code - just plain data list validation. Still this file has lost the sheet reference multiple times.

Entry is done on the booking sheet and validation list is on the customer sheet.

Data validation list : customer!a4:a93
when the sheet name is lost / dissapear validation is done in the booking sheet, where column A contains dates.

Regards
Frank