|
|
Presentation - Working Area
Page visited 9730 times
|
1. To activate the Macro Editor, go to the menu Tools/Macro/Visual Basic Editor (Alt + F11)
|
|
|
|
|
|
|
|
|
2. A new program, distinct of Excel, is opened
|
|
|
|
|
|
|
|
|
3. On the left, a window calls 'Project Explorer' shows you the aborescence of your project
|
|
|
|
|
|
|
|
|
4. You can see the different elements of your Excel file:
The worksheets (including the hided sheets)
|
|
|
|
|
|
|
|
|
5. Your personnal dialog boxes
|
|
|
|
|
|
|
|
|
6. The modules
|
|
|
|
|
|
|
|
|
7. Underneath, a properties windows provides you to change some options (very useful for your personnal dialog box)
|
|
|
|
|
|
|
|
|
8. The window Code, where you'll write your program
|
|
|
|
|
|
|
|
|
|
