What version of Excel are you using? There is no such version as Excel 2014, by the way.
ActiveX controls do not work in Mac Excel, and most people, myself included, will advise you to use controls from the Form menu instead of ActiveX because of reliability.
What version of Excel are you using? There is no such version as Excel 2014, by the way.
I mentioned 2014 in reference to the year in which I can see Microsoft last broke ActiveX, and that applies to Office 2007, 2010 and 2013 which were the available versions of Office at the time (which was 2014). Unfortunately most of those fixes won't apply given that Microsoft never made a fix for this for later versions of Office (such as 2016 or 2019 or Office365)
Last edited: Feb 13, 2019
Sorry, I missed the reference to Office 365 in the subject line. That's what I'm using too (to be precise, build 11330.20014). ActiveX controls were badly broken in Excel 2007, which was more an issue with Office 2007 rather than ActiveX, but by SP2 they weren't quite so bad. But in general, as I noted, ActiveX controls can be rather flaky, despite nominally looking nicer and being more full-featured than Form controls. This was true in Excel 2003 and earlier, and it's been true in Excel 2010 and later. But when my clients use them, then so do I. And so I duplicated your situation. I made a workbook with Sheet1 and Sheet2, then I hid Sheet2, and created CommandButton1 on Sheet1. I right clicked on the button, and inserted your two lines of code into the procedure stub that Excel inserted in the Sheet1 code module. Then, the moment of truth. I turned off Design Mode, then clicked the button. Sheet2 became visible and then was activated.
I can think of a couple things that may have gone wrong. Make sure the button name matches the procedure name. And don't type the entire procedure yourself, but use a right click to view the code, which inserts the appropriately named procedure in the appropriate code module, usually the module behind the sheet that contains the button.
I can think of a couple things that may have gone wrong. Make sure the button name matches the procedure name. And don't type the entire procedure yourself, but use a right click to view the code, which inserts the appropriately named procedure in the appropriate code module, usually the module behind the sheet that contains the button.
Unfortunately, there appears to be a bug in the mrexcel.com forum that prevents the image link embedding from working. Here is the raw URL:
Last edited: Feb 13, 2019
Yeah, that's a strange one. Are there lots of ActiveX buttons? I would try deleting them, saving and closing the workbook, then adding them back. Kind of like turning them all off and on.
Delighting our customers with faster, smoother, and frictionless experiences in Excel for the web is an uncompromised goal across the Excel team. With this in mind, we recently added support to open and edit workbooks with ActiveX, Form controls and other legacy art objects in Excel web.
In response to customer feedback, this represents another step forward to help customers quickly open Excel files and edit them with less friction in the process. This communication is meant to highlight the changes our customers are asking for, and to reaffirm our commitment and ongoing investment in Excel for the web to enable rich end user experiences.
When this will happen:
We expect this rollout to begin in early June and target the rollout to be fully completed by early July.
How this will affect your organization:
Previously when opening a workbook with ActiveX controls or Form controls users would not be able to edit these files directly and would receive a warning telling them these features were unsupported. Users would be redirected to use the desktop version of Excel instead. Users could edit a copy of the document using Excel for the web, which would remove unsupported features.
Excel for the web now enables users to seamlessly open a document which has ActiveX controls, Form controls and other legacy art objects in it. The controls themselves are not usable in Excel for the web and are instead represented with a placeholder image in the workbook. Users no longer receive a warning message when opening their document and can quickly begin working in their document.
What you need to do to prepare:
You may want to notify your helpdesk to make them aware of these improvements, and to prepare them in response to Excel for the web changes / enhancement related helpdesk calls.
Message ID: MC261532
Page 2
Previously, Teams users needed to manually open a chat window to view the chat screen. Now thanks to this new feature, chats sent during a Teams meeting will surface on the screens of all meeting participants, making the chat more central to the conversation.
Key points:
- Microsoft 365 Roadmap ID 65948
- Timing: we will roll this out beginning in mid-July and will be complete by late July.
- Rollout: tenant level
- Control type: user control
- Action: review and assess
How this will affect your organization:
Chat has become a lively space for conversation and idea-sharing and offers an option for people to participate in the discussion without having to jump in verbally. But it can be challenging to pay attention to video feeds, presentations, and chats all at the same time.
With chat bubbles, meeting participants can follow chat on the main screen of a meeting.
You might want to notify your users about this new capability and update your training and documentation as appropriate.
You might want to notify your users about this new capability and update your training and documentation as appropriate.
Message ID: MC261530