double-click on the created button to open Visual Basic mode (ALT+F11) with the automatically created empty frame.enable the Design mode (it is on the «DEVELOPER» tab).If you have used an ActiveX control, then: It is much easier to create a special button. To run it, you need to go to the «DEVELOPER» menu every time, which is inconvenient. Now you need to make it “able to work”.įor example, you have created a macro to perform a specific task. The options that are available on the computer will be offered to choose from. In the «Illustrations» menu, select the «Pictures» tool. You can right-click the finished shape and change its formatting. In the «Recently Used Shapes» menu, select the appropriate shape. The window for assigning a macro opens immediately: you can assign it right now or later at your option. Now select the «Button (Form Control)» element from the first group (the same gray-colored brick). Now draw the button of the required size using the cursor. You need to select the first ActiveX element, that is depicted in in the form of a gray brick. The menu with a set of items to insert will open. Ways to create a graphic object in Excel: Let's consider the order of actions in detail. The essence of the work lies in creating a graphic object and assigning a macro or hyperlink to it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |