WorkBooks

Here you can,

Perform several actions on your WorkBook called “Workbook”. To make this easier, the Sheet that contains most of your data will now be called the “Database”,

Hide the current WorkBook and show the form,

Open a WorkBook that is in the current File,

Open a WorkBook that is in another File,

Save and Close the currently active WorkBook,

Close all workbooks that are currently inactive.

Simply insert the requested value in the box, click on the “Get code” button and Hop, the code appears in the square at the very bottom of the page… copy it and paste it into your UserForm…That’s it 🙂


Masquer le WorkBook actuel et afficher le formulaire:





Ouvrir un WorkBook qui se trouve dans le Fichier actuel:





Ouvrir un WorkBook qui se trouve dans un autre Fichier:





Enregistrer et Fermer le WorkBook actuellement actif:



Fermez tous les WorkBooks actuellement inactifs