Sets of Angles for ExcelAngles Reduction Macro

Version 2.02.2002 beta

© Mark Adams 2002www.EngineeringSurveyor.com

Registration

1. Register this product by entering your name here:

First Name AuthorisedSurname UserCompany www.EngineeringSurveyor.com

2. This information will appear each time you run the macro

Installation

1. Print-out this page and close this Spreadsheet and Excel program2. Start "Windows Explorer"3. Copy this file ("Angles.xls") to a suitable directory: eg: Microsoft Office/Office/Excel/Macros/4. Start "Excel" program5. Select "File", "Open", navigate to the file "Angles.xls" in its new location, click "open"6. Create a shortcut button to start the macro:

6.1 Click the icon to the right, and right-click "Copy"6.2 Right-click an area in the menu bar6.3 Select "Customize"6.4 Select "New"6.5 Enter a name for the new Toolbar6.6 Click "Commands" tab6.7 Select "Macros" from the "Categories" list6.8 Drag "custom button" face icon onto the new toolbar6.9 Right-click new face icon and change name to "Sets of Angles"6.10 Right-click new icon again, select "Assign Macro", select "Sets_of_Angles"6.11 Right-click new icon again, select "Paste Button Image"6.12 Select "Close"

7. Select "Window", "Hide"8. Select "File", Exit"9. At prompt "Do you want to save the changes you made to Angles.xls", select "Yes"

Using Macro

1. Start "Excel" program2. Open GSI file (space delimited)3. Click on "Sets of Angles" icon to begin macro

Windows 2000 Users

To prevent "enable macro" message appearing each time the macro is run:Select "Tools", "Macros", "Security"Change "Security Level" to Low

Mark Adams9th April 2002

6.13 Drag new toolbar/icon into menu area by dragging blue title area