enable personal macro workbook excel 2016 mac

(Of course, the user might still get the yellow-backed messages at the top of the workbook, asking them to click the Enable Editing and/or Enable Macros buttons.) I've never known the problem to occur if no other workbook is open. Then, although I click its 'Enable' button, the Workbook opens, macros do get enabled, but Workbook_Open doesn't run. It happens for me sometimes when I have another workbook already open, then, on trying to open my macro-enabled workbook, before any sheet is displayed I get the Microsoft warning message about macros. I've had this problem (I'm using Microsoft 365), and I found this thread. Given that the Workbook_Open() sub is the gateway to a workbook it seems a little strange that we have to go to a workaround to make it function. It is just this one thing with Excel 2016. In Excel 2010 it works perfectly, as do two other macros in other workbooks for which I have written macros. It is a simple single Sub in the ThisWorkbook module. But a bit 'rough' and it would be good to have the Workbook_Open() sub working correctly. I have produced a work around for my own applications and that is call the activation of a worksheet and call my initialization routines from there. Is this a bug in 2016 and is there a workaround? I notice that unlike Excel 2010, 2016 (365) opens each workbook in its own window, not a workbook window in the Excel application window.

However, if a workbook is already open and then the workbook containing the above Sub is then opened, it does run as expected. The simple event sub Private Sub Workbook_Open()ĭoes not seem to work. Excel 2016 (or 365) does not seem to fire the Workbook_Open() sub reliably or more precisely, not at all!

Enable personal macro workbook excel 2016 mac