Results 1 to 7 of 7

Workbook_Open() not working anymore

Threaded View

  1. #1
    Registered User
    Join Date
    07-06-2022
    Location
    Helsinki, Finland
    MS-Off Ver
    O365
    Posts
    5

    Workbook_Open() not working anymore

    Workbook_Open()
    is not working anymore. I removed a class module from PERSONAL.XLSB which had only one line:
    Option Explicit
    ..and then some commented code. This was related to an old macro which was not in use. Reverting this makes no change.

    I have confirmed that:
    1. I have macros enabled
    2. Exact phrase to call Workbook_Open is:
    Private Sub Workbook_Open()
    4. Workbook_Open() is called in ThisWorkbook object
    5. Events are enabled, I ran:
    Application.EnableEvents = True
    in VBA Immediate window. Then
    ?Application.EnableEvents
    and got result:
    True
    Other macros run normally as before, Workbook_Open() just does not fire up on opening workbooks anymore.

    Now I have done all of this:
    - Used Windows Apps & Features 'Repair' function for Office
    - Digitally signed the macros in workbook
    - Tested Excel's every setting for Macro security
    - Tested with a new workbook, both .xlsx and .xlsb
    - Tested different settings of Protected View
    - Added OneDrive and a network folder as Trusted locations
    - Opened workbook from local hdd, not network or OneDrive?
    - Ran Excel as administrator
    - Tried a 2 week old backup of PERSONAL.XLSB
    - Removed all add-ins, DAX-studio stays
    - Uninstalled DAX-studio
    - Used Windows Apps & Features 'Reset' function for Office
    - Unistalled Office
    - Reinstalled Office - My ribbon customization remained as well as recent and pinned workboos. Apparently uninstall does not remove every bit of Office.

    When I start Excel, from shortcut, WorkbookOpen() is triggered. Meaning, when PERSONAL.XLSB is opened the macro runs. But it's not running when I open a Workbook, by any method, double-clicking in explorer or File → Open from Excel itself.

    Starting to be a bit desperate here. Thought reinstall at least woud have fixed this but no. Anyone any ideas?

    Crossposted here: https://www.mrexcel.com/board/thread...kbook.1212578/
    Last edited by Glenn Kennedy; 08-18-2022 at 10:11 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] FTPPutFileA not working anymore?
    By Andrew Entee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2022, 01:04 PM
  2. [SOLVED] excel-2016 workbook_open event doesn't trigger anymore
    By Keebellah in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2021, 04:01 AM
  3. F1 Help key not working anymore
    By Phil8 in forum Excel General
    Replies: 0
    Last Post: 09-16-2017, 10:13 AM
  4. [SOLVED] CSV to XLSX Not Working Anymore
    By kas.samrari in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-24-2016, 07:41 PM
  5. VBA Macro not working anymore
    By winsomeness in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2015, 08:20 PM
  6. VBA code not working anymore
    By random379 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2012, 03:01 AM
  7. Filter is not working anymore.
    By Berry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2006, 02:45 AM

Tags for this Thread

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