Results 1 to 6 of 6

Trust Center disable macros setting does not always defeat Workbook_Open

This is a discussion on Trust Center disable macros setting does not always defeat Workbook_Open within the Excel Questions forums, part of the Question Forums category; I have been working in VBA for 20 years and never seen this. Note I just upgraded to 32-bit Office ...

  1. #1
    New Member
    Join Date
    Jun 2017
    Posts
    3

    Default Trust Center disable macros setting does not always defeat Workbook_Open

    I have been working in VBA for 20 years and never seen this.

    Note I just upgraded to 32-bit Office 365 Pro Plus Version 1612 (Build 7668.2074) on 64-bit Windows 7 Enterprise SP1. All Windows and Office updates allowed by the company IT admins are in place.

    I have two workbooks with Workbook_Open macros. One is very small, the other extremely large and complex. When I tell Trust Center to disable macros without notification the small workbook obeys but the large workbook rebels and runs Workbook_Open anyway. In addition, after the workbook has opened completely and is ready, I can run any macro on demand and event procedures all work perfectly.

    What gives?

  2. #2
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,082

    Default Re: Trust Center disable macros setting does not always defeat Workbook_Open

    Is the large workbook in a trusted location on your computer and the smaller one not?
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  3. #3
    New Member
    Join Date
    Jun 2017
    Posts
    3

    Default Re: Trust Center disable macros setting does not always defeat Workbook_Open

    Quote Originally Posted by MARK858 View Post
    Is the large workbook in a trusted location on your computer and the smaller one not?
    I have one trusted location -- a Sharepoint server I never use and no, these workbooks have nothing to do with Sharepoint.

  4. #4
    shg
    shg is offline
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    19,150

    Default Re: Trust Center disable macros setting does not always defeat Workbook_Open

    Are you opening the small workbook manually and the large one programmatically?
    Last edited by shg; Jun 19th, 2017 at 12:53 PM.

  5. #5
    New Member
    Join Date
    Jun 2017
    Posts
    3

    Default Re: Trust Center disable macros setting does not always defeat Workbook_Open

    Quote Originally Posted by shg View Post
    Are you opening the small workbook manually and the large one programmatically?
    No, my test only involved manual open.

  6. #6
    shg
    shg is offline
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    19,150

    Default Re: Trust Center disable macros setting does not always defeat Workbook_Open

    I've never seen that happen. I would try running AppsPro CodeCleaner on the file, but only because it's the only thing I can think of.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com