• Dear Microsoft, don’t give up on this please!

    Home » Forums » Newsletter and Homepage topics » Dear Microsoft, don’t give up on this please!

    Author
    Topic
    #2459004

    I’m guessing that big businesses pushed back on this. But Microsoft? Don’t give up on making this default. We need macros to be off by default and let
    [See the full post at: Dear Microsoft, don’t give up on this please!]

    Susan Bradley Patch Lady/Prudent patcher

    5 users thanked author for this post.
    Viewing 8 reply threads
    Author
    Replies
    • #2459037

      Susan,
      Cryptic header and text that doesn’t say what was the feature that Microsoft is rolling back.

      For once Microsoft listened to their users 🙂

      • #2459077

        No, they reacted to one or two large businesses, not the masses that want help protecting us from ransomware.

        They were planning to disable macros by default in Excel spreadsheets opened from the web.  This isn’t listening to customers.

        Susan Bradley Patch Lady/Prudent patcher

        • #2459097

          Ian McShane, VP of Strategy at Arctic Wolf 

          It’s unfortunate and disappointing that Microsoft is walking back their security by default initiative around office macros. Disabling office macros by default would have been a huge step forward for securing one of the most tried and tested attack paths, since malware like Quakbot and Emotet are distributed through these kinds of malicious docs, wreaking havoc on organizations worldwide. Whether this was rolled back due to technical concerns or customer feedback, office users are less secure today than they were last week; security teams need to be on high alert, and re-remind users about the risks of active content in office docs. While I was surprised to hear that there were plans to address it with a default macro disable, I’m even more surprised that those plans are being backpedaled. 

          Overall, the question of usability vs. security is a huge problem to solve, but the user hurdle of disabled macros is a far smaller price to pay than picking up the pieces of a successful Emotet attack. This attack path has been a well-known problem for decades and unfortunately, the approach to mitigating the risk of macros has always been on the end user, rather than fix at the source. I would be prepared for a spike in macro based cyber attacks, now that this attack path has been made easier again. 

          Susan Bradley Patch Lady/Prudent patcher

          2 users thanked author for this post.
    • #2459107

      They were planning to disable macros by default in Excel spreadsheets opened from the web. .

      This should have been at the opening of your post.

      I knew that but I don’t think many do.

    • #2459156

      Hi Susan:

      Thanks for posting about this.  I’ve been following comments in Amit Rakibe’s Microsoft Has Blocked Macros From Running Because the Source is Untrusted in the MS Answers forum for a few weeks now and posted a link there to your full article.

      I gather there’s still quite a few users having problems opening Excel workbooks stored on a file server on their LAN.  Many users in that thread have had to re-map their network drive (I assume this means their file server) where the Excel workbooks are saved using the standard UNC naming convention [e.g. \\<servername>\<sharename> instead of the IP address of the server (e.g. \\[192.xxx.xxx.xxx]\<sharename>)] and then add that re-mapped share to the trusted locations in Excel (File | Trust Centre | Trust Centre Settings | Trusted Locations), but that solution hasn’t worked for everyone.

      • #2459183

        If they remove the mark of the web that should help as well.  Anytime you have an Excel file that you want to use, you’ve vetted and that you want to trust, you should go into properties of the file and ensure it doesn’t have “mark of the web”.

        Susan Bradley Patch Lady/Prudent patcher

        1 user thanked author for this post.
        • #2459245

          If they remove the mark of the web that should help as well..

          Hi Susan:

          I’m a bit confused by the instructions in the Microsoft Docs article Macros From the Internet Will be Blocked by Default in Office. The “Prepare for Change” section at the top of that article says “Have users clear the Unblock checkbox on the General tab of the Properties dialog for the file to make it a Trusted Document (which sounds to me like they should uncheck / disable that Unblock checkbox) …

          vba-unblock-file-properties

          …but the Mark of the Web and Trusted Documents section of that same Microsoft Docs article says that users should “select Unblock, which will remove Mark of the Web from the file and allow the macros to run, as long as no policy or Trust Center setting is blocking.

          A few users posting in Amit Rakibe’s Microsoft Has Blocked Macros From Running Because the Source is Untrusted thread in the MS Answers forum said they checked / enabled that Unblock check box and still couldn’t open Excel files that contained VBA macros, even after they re-mapped their network drive (file server) and added the share to the Trusted Locations in Excel.

          I know a bit about Windows server administration but I’ve never worked as a system admin and I’m not personally affected by this problem on my home computer.  However, after reading the comments in Amit Rakibe’s thread it sounds like Microsoft didn’t anticipate how much difficulty some users would have trusting Excel workbooks containing VBA macros once this policy change went live.  It’s unfortunate, but I can see why Microsoft decided to temporarily roll back this change.
          —————
          Dell Inspiron 5584 * 64-bit Win 10 Pro v21H2 build 19044.1766 * Firefox v102.0.1 * Microsoft Defender v4.18.2205.7-1.1.19300.2 * Malwarebytes Premium v4.5.10.200-1.0.1709 * MS Office 2019 Home and Business Version 2206 (Build 15330.20230 Click-to-Run)

          • #2459250

            Self-sign Your Macros For Co-workers – Excel Tips – MrExcel Publishing

            One of the posters talks about how these are self-prepared excel files.  They need to do that step as it will make his life MUCH easier.

            Susan Bradley Patch Lady/Prudent patcher

          • #2459882

            Hi Susan:

            I’m a bit confused by the instructions in the Microsoft Docs article Macros From the Internet Will be Blocked by Default in Office. The “Prepare for Change” section at the top of that article says “Have users clear the Unblock checkbox on the General tab of the Properties dialog for the file to make it a Trusted Document (which sounds to me like they should uncheck / disable that Unblock checkbox) …

            That section has now been corrected by Microsoft, replacing “clear” with “select” (after I added a comment to that page about the error):

            Have users select the Unblock checkbox on the General tab of the Properties dialog for the file to make it a Trusted Document.

            Macros from the internet will be blocked by default in Office

            1 user thanked author for this post.
    • #2459188

      According to Neowin Microsoft said the change is temporary.

      Update: In a statement to Neowin, Microsoft has confirmed that this is only a temporary reversal of configuration, the full comment can be seen below:

      Following user feedback, we have rolled back this change temporarily while we make some additional changes to enhance usability. This is a temporary change, and we are fully committed to making the default change for all users.

      Regardless of the default setting, customers can block internet macros through the Group Policy settings described in this article.

      We will provide additional details on timeline in the upcoming weeks.

    • #2459235

      I wonder if the pushback was due to files being marked as “from the Internet” when downloaded from Sharepoint?  A lot of companies are using Sharepoint for file storage these days due to the ability to co-edit files and the ability to access the files without going through a VPN.  With so many people working from home for the past couple of years, it put quite a strain on VPN infrastructure, and one way to avoid upgrading the VPN is to make files accessible through Sharepoint instead of using network drives.

    • #2459330

      Just out of curiosity, does this apply to Libreoffice? I often find VBA macros auto on there, and manually switch off.

    • #2459336

      does this apply to Libreoffice?

      Libreoffice isn’t Microsoft software.
      Libreoffice, Openoffice and other office clones may follow Microsoft, or not.

    • #2464782
      2 users thanked author for this post.
      • #2464787

        Current Channel — Version 2206

        Begin rolling out on July 27, 2022

        1 user thanked author for this post.
    • #2464786

      FYI

      Bleeping Computer – Microsoft resumes default blocking of Office macros after updating docs
      ———————————————————–
      https://www.bleepingcomputer.com/news/microsoft/microsoft-resumes-default-blocking-of-office-macros-after-updating-docs/

      “Microsoft announced today that it resumed the rollout of VBA macro auto-blocking in downloaded Office documents after temporarily rolling it back earlier this month following user feedback.

      The change comes after the company improved its user and admin support documentation to make it easier to understand the available options when a macro is blocked.”

      HTH.

      1 user thanked author for this post.
      b
    Viewing 8 reply threads
    Reply To: Dear Microsoft, don’t give up on this please!

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: