Combination: DataValidation auto appear + show all rows

[helmekki]

Hi there

I use this code to make my Drop down Data validation drops automatically,
the code :

Please Login or Register  to view this content.

In addtion to this i use another code to make the drop down data validation show all the visible list rows of the Data Validation list.
the code :

Please Login or Register  to view this content.

The Need:
I tried to combine both codes to make my drop down data validation appears automatically and shows all the visible list rows of the Data Validation list ?

but without success.................couold you pls help in the case

[helmekki]

any idea ?

[helmekki]

???..........