Source d'un menu déroulant

%3CLINGO-SUB%20id%3D%22lingo-sub-1406595%22%20slang%3D%22fr-FR%22%3ESource%20of%20a%20drop-down%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406595%22%20slang%3D%22fr-FR%22%3E%3CP%3EI%20have%20a%20drop-down%20menu%20that%20has%20this%20source%20in%20the%20same%20document%20but%20another%20tab.%20I%20would%20like%20the%20source%20to%20be%20a%20new%20file%20now.%20This%20file%20would%20be%20the%20master%20and%20with%20protection.%3C%2FP%3E%3CP%3EHow%20to%20do%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1406595%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1406818%22%20slang%3D%22en-US%22%3ERe%3A%20Source%20d'un%20menu%20d%C3%A9roulant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406818%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F674754%22%20target%3D%22_blank%22%3E%40Yohan22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20do%20you%20need%20to%20have%20the%20source%20in%20a%20different%20file%20with%20a%20password%3F%20If%20you%20want%20it%20to%20be%20non%20editable%20you%20can%20try%20to%20enter%20Developer%20Tab.%20There%20open%20Visual%20Basic%20and%20change%20the%20sheets%20visibility%20to%20%22Very%20Hidden%22%20to%20keep%20it%20hidden%20and%20this%20way%20it%20will%20not%20be%20visible%20in%20Show%2FHide%20Sheets%20list.%20Would%20probably%20prevent%20most%20of%20the%20users%20to%20see%20it.%20And%20also%20you%20can%20password%20protect%20the%20sheet%20if%20you%20wish.%3C%2FP%3E%3CP%3EIf%20you%20need%20a%20seperate%20file%20with%20a%20password%20protection%20you%20need%20to%20open%20it%20via%20a%20macro%20as%20you%20cannot%20read%20data%20from%20a%20pasword%20protected%20files%20than%20read%20the%20data%20with%20macro%20again%20or%20Power%20Qery.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

J'ai un menu déroulant qui a ça source dans le même document mais un autre onglet. J'aimerais que la source soit maintenant un nouveau fichier. Ce fichier serait le master et avec protection.

Comment faire?

 

Merci

1 Reply
Highlighted

@Yohan22 

Why do you need to have the source in a different file with a password? If you want it to be non editable you can try to enter Developer Tab. There open Visual Basic and change the sheets visibility to "Very Hidden" to keep it hidden and this way it will not be visible in Show/Hide Sheets list. Would probably prevent most of the users to see it. And also you can password protect the sheet if you wish.

If you need a seperate file with a password protection you need to open it via a macro as you cannot read data from a pasword protected files than read the data with macro again or Power Qery.