How To Assign A Macro To A Button In Excel For Mac

Add Macro Button to the Toolbar in Excel 2011. Right click on the toolbar and select Customize Toolbars and Menus then. Click the Commands tab, then. Scroll down and select Macros from the Categories pane,. Drag the Custom Button with a smiley face to the toolbar, then. Click OK to get rid of the dialog box. Right Click on the form button, then on Assign Macro. In the next dialog box, Click on New. Press fn+ALT+F11 to access the VBA Editor. Create a sub in a module and then link it to the form button using Assign Macro as mentioned above. Click on the Excel Menu next to.

I have a spreadsheet with several macros - fairly simple but also quite lengthy. The macros were written in excel 2003. At the time, we created custom buttons to execute the macros. The buttons were assigned to a toolbar.

This was all done in about 2007 and all on windows based pc's. It was a collaborative effort with a friend of mine. Fast forward to today. I have the spreadsheet on my imac.

The custom buttons all show up in the add-ins menu and do what they are supposed to do. This is great - but I need to see how the macros are assigned to the buttons. This has to do with running the same spreadsheet on a windows based pc. The add-ons work there as well - but they open up another spreadsheet when they are executed.

I'd like to kill that link, somehow. From what I've read I should be able to right click on the button and it will open the assign macro feature and allow me to view the assignment. But right clicking on the button does nothing. I've tried control + command + right click and get nothing. (as well as shift + rc, fn + rc, cntl + rc, option + rc, command + rc).

I've tried it with my magic mouse which has right click enabled and I've tried it with a logitech mouse I use for autocad. I can edit the macros themselves.

They do not link to an external spreadsheet within the macro, and I have no problems executing the macros via the buttons on the imac where the external spreadsheet does not exist. Is any part of of the Macros were written using ActiveX controls, they will not work, I know nothing about how to write Macros. So I will Leave it to, the two Bob's, J.E. McGimpsey, or John McGhie or several other MVP's, expert in this to answer.

Back in the 90's when I first experience Word and Excel everyone was warned to turn off macros unless there was a vital need, because there were dangerous viruses capable erasing your Hard Drive and destroying your files, even making hard drive unusable in Windows, DOS, and in Mac. All were were equally at risk.

I've only in the last couple of years turned off that warning (written into Office year to year), so that I could use a DatePicker Macro in Excel. I'm not a Fan of using any languages such VBA, Macros, or AppleScript. Open up applications to too much outside control if written wrong. Quickbooks enterprise contractor for mac.