So you saw how to run the GetPoints VBA in the VBA with Pro/D tutorial. Wouldn't it be nice to be able to add a button to the Pro/D Menu in excel? This tutorial will show you how to add a button to the excel Pro/D toolbar that calls the GetPoints VBA.

• Open Excel
• Open the excel integration worksheet ProDeskTop2000iTools.xls For more information concerning the use of this spread sheet see the Pro/D Excel Integration Tutorial.
• Make sure the Pro/D Toolbar is visable in excel View>Toolbars>Make sure the Pro/D toolbar is checked.

• First you must explain to excel that there is a new macro for it to use.
• Will the ProDeskTop2000iTools.xls is open.
• In excel hit Alt-F11 to activate the VB Editor.
• File>Import> Browse to the GetPoints.bas File.
• It will add GetPoints as a module.

Now you will be able to use the GetPoint Macro in Excel. To make using it easy lets assign a button to it

To assign a button to the new macro:

• View>Toolbars>Customize>Select the Command Tab
• In the Catagories selection area select MACROS
• In the Commands Window select Custom Button
• Drag the Custom Button Icon to the Pro/Desktop Toolbar

Click on the new button created then choose modify selection in the Customize Window

If you closed the customize window just right click the new button and select customize then click on the new button

You can change the button image and assign the GetPoint macro to the button from the modify selection menu