Chúng tôi lặp lại quá trình cho tất cả các màu sắc và các macro sao lưu cho đến khi chúng ta còn lại với một thanh công cụ trông giống như hình 8-10Hình 8-10: Các thanh công cụ điện trở. Nhấp vào bất kỳ một trong các nút nên chạy vĩ mô cập nhật các ban nhạc trên điện trở. | Example 8 Resistor Color Code Decoder Using Speech Input Figure 8-7 Creating a customized toolbar. Figure 8-8 Placing a button on the new toolbar. 135 Excel by Example Right-click on this smiley and on the pop-up menu Figure 8-9 change the Name to Commence select Text Only Always and Assign Macro assigning the button to the macro of the same name. Irritatingly this process may take several right-clicks. Figure 8-9 Changing button properties. Reset Delete Name Commence Copy Button Image Paste Button Image Reset Button Image Edit Button Image. Change Button Image Default Style T I Text Only Always Text Only in Menus Image and Text Begin a Group Assign Hyperlink Assign Macro. We repeat the process for all the colors and the Backup macros until we are left with a toolbar that looks like Figure 8-10. Figure 8-10 The Resistor toolbar. Clicking on any one of the buttons should run the macro updating the bands on the resistor. We can get rid of the toolbar by clicking the X on the top right-hand corner and make it reappear or disappear by right-clicking on a toolbar and selecting or deselecting the Resistor option. Of course it is possible to delete entirely by going into Tools Customize Resistor Delete but I don t think we should do that just yet. In Parenthesis Exporting a Toolbar Toolbars are normally associated with an Excel installation. They can be inserted into a workbook for transportation which is what I hope will happen with this example. In the customize dialog Figure 8-7 having selected the Toolbars tab click on the Attach button. In the next dialog box that appears select the desired toolbar in the Custom Toolbars panel and click on the Copy button between the panels. The toolbar should be copied to the Toolbars in Workbook panel. Click on OK. 136 Example 8 Resistor Color Code Decoder Using Speech Input Adding Speech We now re-enable the Language toolbar using the menu selections Tools I Speech I Speech Recognition. Ensure that the microphone is in the record
