Sub Macro1(control As IRibbonControl) Press OK. This resulted in a long code but… As I’m totally ignorant about VBA I decided to just pat myself in the back for even getting it to work. 5) Excel 2010 vba replacement of application filesearch in Excel. This worked perfectly when I ran the macro afterward. consequently if you click on the middle one it gets amber and the. Depending on how you’ve set up those buttons, they might be linked to the whole path of the workbook that contains the macro. For example, if you wanted to run MyMacro when cell A1 was double-clicked, it would look something like the following. Application.Caller will return the name of the form button that called the procedure.

Vba add a link in a sheet to another sheet.