Add Button And Assign Macro To It. Click Add to move the macro to the list of buttons on the Quick Access Toolbar. If everything working well now we can consider a button for this macro.
Then select Customize the Ribbon. Using With to avoid select statements then assign the properties of the command button however you see fit. How do I do that.
Right click doesnt work and my macro isnt appearing.
Please click Developer Insert and then select the first option under the Form Controls section see screenshot. Go to Developer tab 4. Select the macro youd like to assign to the button and click on OK. Draw a button in working area.