Excel for the Mac Tips. In July 2011, I started working with Office 2011 on my first Mac computer. My idea is to go through all my Excel for Windows tip pages and see if I can also get the VBA code working in Excel 2011. Converts a Microsoft Office Excel name to an object or a value. Export(String, Object, Object) Exports the chart in a graphic format.
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. 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. 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 WorksheetSelectionChange(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. Another update: So I have rolled my excel back to Version 15.36 (170702) and guess what. Pressing the form control button to run the save and close macro does NOT crash Excel. I have rolled forwards to Version 15.41 (171205) and still no crash issues. If I roll forwards to Version 16.9 (18011602) and Excel crashes when I press the Form Control Button.
In my opinion then, a bug has been induced in the update from version 15.41 to version 16.9 Hopefully Microsoft will bug fix this quickly. I would be interested to know if others who have used Buttons to run a close macro have also experienced crash of Excel?
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |