+ Reply to Thread
Results 1 to 5 of 5

Macros and VBA code not running even though enabled in trust center

Hybrid View

  1. #1
    Registered User
    Join Date
    03-20-2020
    Location
    Idaho, USA
    MS-Off Ver
    365
    Posts
    4

    Macros and VBA code not running even though enabled in trust center

    Hi all,

    Thanks for taking a look at my question. My company uses a quote tool that is an excel file on steroids - which just means it has a bunch of macros and VBA code. As of this morning, no one can use the file. It has been working fine for some time but now when opened, it says that "The macro may not be available in this workbook or all macros may be disabled." I have enabled all macros in the Trust Center, we have not changed any security settings and have not changed/added/modified any VBA code. I noticed that we were getting micrsoft security essentials pop-ups and found a Virus: TrojanDownloader:O97M/Obfuse.DF!MTB, so I am not willing to upload a copy of the file in case this is the issue. I am not familiar with viruses but assume they can affect things like this? We have quarantined and removed it but still having issues opening the WB.

    Any thoughts would be much appreciated. Not sure if we have a virus or just a technical "know how" issue.

    Thanks so much in advance!

    Ryan

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,826

    Re: Macros and VBA code not running even though enabled in trust center

    Any Microsoft Updates for Windows or Excel overnight?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-20-2020
    Location
    Idaho, USA
    MS-Off Ver
    365
    Posts
    4

    Re: Macros and VBA code not running even though enabled in trust center

    Hey TMS. Not that I can tell. I do not see any in the history.

  4. #4
    Registered User
    Join Date
    03-20-2020
    Location
    Idaho, USA
    MS-Off Ver
    365
    Posts
    4

    Re: Macros and VBA code not running even though enabled in trust center

    I see a microsoft office 365 program that was installed on 3/17. I wonder if that is contributing...researching the Version now.

  5. #5
    Registered User
    Join Date
    03-20-2020
    Location
    Idaho, USA
    MS-Off Ver
    365
    Posts
    4

    Re: Macros and VBA code not running even though enabled in trust center

    It's virus related. Apologize for taking up your time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. All Macros Are Enabled, But Macros Are Still Not Running
    By chasfh in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 06-04-2019, 07:23 AM
  2. Replies: 3
    Last Post: 07-20-2018, 12:54 PM
  3. Replies: 0
    Last Post: 05-22-2017, 08:11 AM
  4. trust center
    By pyrohac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2015, 07:08 PM
  5. Excel 2010 - Lock out Trust Center settings for Disabling All Macros?
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-13-2014, 10:31 AM
  6. Excel 2010 Trust Center - How to Un-Trust
    By PosseJohn in forum Excel General
    Replies: 3
    Last Post: 08-04-2013, 01:57 PM
  7. Excel 2007 : Cant get trust center
    By amsanborn in forum Excel General
    Replies: 4
    Last Post: 07-22-2010, 12:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1