Re : menu deroulant autre classeur
Re,
Voici la procédure dans sa version originale (trouvée sur l'aide d'excel, version anglaise désolée) c'est peut être plus clair ... entre parenthèse et en italique sont les explications des mots ...
----------------------------
Open both the workbook that will contain the link (called the destination (destination file: The file that a linked or embedded object is inserted into. The source file contains the information that is used to create the object. When you change information in a destination file, the information is not updated in the source file.) workbook), and the workbook that contains the data you want to link to (called the source (source file: The file that contains information that was used to create a linked or embedded object. When you update the information in the source file, you can also update the linked object in the destination file.) workbook).
In the destination workbook, point to Name on the Insert menu, and then click Define.
In the Names in workbook box, enter the name for the link.
Delete the contents of the Refers to box, and keep the cursor in the box.
If the name is a formula, enter the formula, and position the cursor where you want the link. For example, type =SUM(), and position the cursor between the parenthesis.
On the Window menu, click the name of the source workbook, and then click the worksheet that contains the cells you want to link to.
Select the cell or range of cells you want to link to.
In the Define Name dialog box, click Add.
----------------
Minipuce
Edit : bien d'accord avec toi PascalXLD, c'est à nananini de choisir la solution qui l'intéresse le plus, perso, j'aurai préféré caché ma feuille.
