What Is The Control Button For Exel On Mac

Hi Banjo060664, As your friend has Office 365 and therefore 5 licenses available, any chance you can install Office 365 on your mac and registrer with his account? This would pin down the problem to your version of Office. After you're finished with the testing your friend can go to the Office 365 control panel and remove the license from your device. Regards Simon If you find that my post has answered your question, please mark it as the answer. If you find my post to be helpful in anyway, please click vote as helpful. Regards Simon Disclaimer: This posting is provided AS IS with no warranties or guarantees, and confers no rights. I subscribe to trial Office 365.

All that actually does is put Office 2016 for Mac back on my laptop. So I have uninstalled Office, and then reinstalled it. I create a basic.xlsm spreadsheet. use VBA to include this macro Sub SaveAndClose() ActiveWorkbook.Close SaveChanges:=True End Sub If I simply Run the macro. If put a Button (Form Control) on the sheet, and assign the macro to it. Then when I click the button, Excel crashes, with the same error report as previously listed. Just cant get any help direct from Microsoft.

Hi Banjo, You could also try to downgrade Excel to a previous version by following this: Please refer to this: • Go into one of the office Apps and choose Help > Check for Updates at the top of the screen. Turn off automatic updates. • Find the previous version of the particular application you want to revert (Word, Outlook, Powerpoint, Excel) on the Office Update History for 2016 page:. You can download the installer package for the individual app and not the whole Office 365 update by clicking the links on the right hand side (Word, Excel, etc). • Before opening the update pkg, delete the application (Word, Excel, etc) from your Applications folder in the Finder.

It will go to the trash (in case you need to restore it). • Open the installer package and it will re-install the previous version for you. You may need to open it and force quit 1-2 times before it will function correctly again for some reason. • Wait until a later date and try updating again when hopefully the bugs have been worked out:), and if you have time, post on here about your problem, so that they can work on a fix to it. Regards Simon If you find that my post has answered your question, please mark it as the answer. If you find my post to be helpful in anyway, please click vote as helpful.

Regards Simon Disclaimer: This posting is provided AS IS with no warranties or guarantees, and confers no rights. Simon, thanks for your advice. As an update: I have created a basic.xlsm file with a simple macro in it. Sub SaveAndClose() ActiveWorkbook.Close SaveChanges:=True End Sub I have inserted a button on Sheet1 and assigned this macro to it. I have emailed this file to 4 different colleagues. Using Office 2011 for Mac - no problems 2. Using Office 2016 for Mac - version 16.9 (apparently no problem) 3.

Firewire to firewire cable. Using Office 2016 for Mac - Version 15.22 (165006) excel crashed on pressing button 4. Using office 2016 for Mac - Version 15.40 (171108) -no apparent problem This seems inconclusive to me Of note, I also created the same simple Excel.xlsm file on my wife's Office 2011 for Mac laptop, and emailed it to my laptop.

It still crashed on pressing the Form Control Button. If I make a change to the macro to get it to simply save the spreadsheet.

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF. I’ve been using your web page for a while now and let me tell you, it is the best page for excel ever made! In the name of me and a lot of the people that I’ve showed this, THANKS! 'Home' Button in mac. Discussion in 'Mac Basics and Help' started by chan2004, May 26, 2008. Most Liked Posts. I'm working on an excel spreadsheet, and need to find the equivalent to the Home Key and the End Key to bring me to the very first and very last cells. Remove the Control key from the shortcuts and you've got it. Home is just.

No crash, so it seems that it is the use of a Form Control button to run a macro that closes a spreadsheet that causes the issue. Remember, from my original post: My 'Save and Close' Macro works OK if I simply run the macro, and it also works if I use a Worksheet_SelectionChange(ByVal Target As Excel.Range) BUT if I insert a Button (Form Control Button from Developer Toolbar) it crashes on use I will try to roll back my Excel and see what happens, and while it may resolve my problem immediately, one of my spreadsheets is used by a lot of work colleagues, who may well also have similar hardware and software to me, namely.