What Every Engineer Should Know About Excel, Second Edition by J. P. Holman & Blake K. Holman

Author:J. P. Holman & Blake K. Holman [Holman, J. P.]
Language: eng
Format: azw3, pdf
Publisher: CRC Press
Published: 2017-10-12T04:00:00+00:00

FIGURE 5.25

A rectangle drawing object is created and the macro name Macro1 is typed inside. The macro is assigned by activating the rectangle, right clicking, followed by Assign Macro with Macro1 selected in the dialog box.

A special button is created by clicking DEVELOPER/INSERT/Button. The Assign Macro box will appear. Make the assignment and then click OK. The button will remain activated; if not, activate by pressing CTRL while clicking on the periphery of the button. Type the title of the macro in the button using a desired style and font.

Note that for this special button procedure, the user must enable the DEVELOPER toolbar. This is accomplished by selecting FILE/OPTIONS/Customize Ribbon and then checking the Developer option on the right-hand side of the Customize Ribbon window.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.