The Assign Macro window will pop up and you can select the VBA procedure you want to run from the button.Right click and hold the mouse then drag and release to create your button.Select the Button Form Control from the menu.Press the Insert button found in the Controls section.If you don’t see this tab, read How To Enable The Developer Tab. Go to the Developer tab in the ribbon. without them having the Developer tab enabled) then a form control button is a good option. The good thing about form control buttons is they can be made very prominent and labelled accordingly like “Click Here To Run” so a user will know what to do. If you have a workbook that uses some VBA code and you want an easy way for someone to run the code (i.e.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |