Excel 2016 cannot record macro or add ActiveX control in v.1809

  1.    1 Week Ago #1

    Excel 2016 cannot record macro or add ActiveX control in v.1809


    This thing, with version 1809, is getting better and better every day.

    I just found out that I can neither record macros in Excel 2016 x64 nor I can add ActiveX controls.

    That's what I'm getting, when trying either one of them:

    Click image for larger version. 

Name:	Excel.png 
Views:	1 
Size:	81.6 KB 
ID:	220921


    As it turns out, I'm not the only one in this world having this issue. And how could I possibly be, when we're talking about the Redmond geniuses?

    In the Microsoft Community a lot of people have similar issues.
    One user has stated that after installing Windows 10 Build 18309.rs_prerelease.181220-1256, the problem is resolved.

    Does anyone have similar problems?
      My ComputerSystem Spec

  2. bro67's Avatar
    Posts : 5,640
    Mac OS High Sierra 10.14.3 Beta (18D21c)
       1 Week Ago #2

    You have to enable TragicX, since it is considered non-trusted for Macro's. Enable or disable ActiveX settings in Office files - Office Support Also see this. https://support.microsoft.com/en-us/...nsert-controls Not the first time that Microsoft has broken their own software. https://support.microsoft.com/en-us/...solution-after
      My ComputerSystem Spec

  3.    1 Week Ago #3

    bro67 said: View Post
    You have to enable TragicX, since it is considered non-trusted for Macro's. Enable or disable ActiveX settings in Office files - Office Support Also see this. https://support.microsoft.com/en-us/...nsert-controls Not the first time that Microsoft has broken their own software. https://support.microsoft.com/en-us/...solution-after
    Thanks a lot for your suggestion.
    I tried the fix proposed by Microsoft, but unfortunately it didn't help.
    It seems that I have to wait for the next FU (as suggested by a user in the MS forum), hoping that it will fix all the mess created by 1809.
      My ComputerSystem Spec


 

Related Threads
Add a shortcut to an Excel Macro in Microsoft Office and 365
W10 and Excel. I have several macros in my personal.xls all activated from a customized ribbon or Quick Access. I would like to add a KB shortcut to 2 of them. I know I should have done that when I created them but I did not realize then how...
Solved Excel Using control to copy data in Microsoft Office and 365
Hi ,,I want to copy =e7,=e9,=e11,, you know what I mean, select a cell, press Ctrl and select down a part of a column, but each cell says =e7,=e8,=e9,=e10,,,what I want is =e7,=e9,=e11,=e13,,can someone tell me how please instead of me having to...
so jump lists via my taskbar and windows 10, I'm not having much joy :-( I've just got a new desktop (Jan 2016) with windows 10 pre-loaded and I installed office 2010 - jump lists didn't work - so I thought I'll uninstall and install office 2016...
Source: October 2016 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs How to Check for Updates in Office 2016 for Windows
Source: September 2016 updates for Get Transform in Excel 2016 and the Power Query add-in - Office Blogs
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 00:39.
Find Us