quick access to macro ribbon in Excel
Q136. I frequently use a Macro - is there a way to quickly access the Macro in the Excel Ribbon?
To do it in Excel, here is the answer:
a) Click on the small "line with down arrow" in the "Quick Access Toolbar" on the Top Left of the Excel Window. Click on "More Commands..."
b) In the "Excel Options" dialog box that pops up, select "Macros" under "Choose commands from:" field. Select the Macro that needs to be added to "Quick Access Toolbar" as shown below.
c) Click on Add. Click OK.
d) The "SendDataToftp" example Macro is now added to Quick Access Toolbar for single click access.