You can access the VBA environment in Excel 2011 for Mac by opening the Visual Basic editor. First, be sure that the Developer tab is visible in the toolbar in Excel. The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form Controls like buttons, checkboxes, etc. ![]() Hi - I have Office 365 installed on 2 mac's. On the one I created and edited macros with no issues. However when I opened the same file on the other mac and attempted to edit one of the macros within the VB editor, the editing toolbar is missing and I cannot find any option to show it. This is strange as I am using identical software (Office 365 Excel version 15.18) on both machines which are both Mac yet on the one the toolbar is visible but on the other it is not. And further to this, if your computers are joined to a domain then you can look at the computer accounts in Active Directory. You can get to it from the system menu, under Accessories. These should tell you about the machine. You can do this with Windows PowerShell, which is installed by default in Windows 7. The command that you can use is. How do you find the command name for a program in os x 10.11. ![]() Just to stress, I am referring to the editing toolbar that appears in the visual basic development window. Thank you for any assistance you can give. Hi Tam253, There is no way that what you are reporting is coming from the same version of Office 2016 for the Mac across multiple computers. The current version is 15.26 and no version since 15.0 was released has included a proper VBE editor. This is a major shortcoming of Mac Office 2016 and reportedly is being worked on by Microsoft. Onyx for mac sierra 10.13. But personally I am not holding my breath that this will occur anytime soon. You are probably looking at the VBE from 2011 and 2016 versions of Mac Office so I am unsure of how anyone can be of assistant with your question until you triple check the installed version of Office on these computers of yours. Kind Regards, Rich.
0 Comments
Leave a Reply. |