Results 1 to 3 of 3

Workbook Open and Activate not functioning

Threaded View

brucemc777 Workbook Open and Activate... 06-16-2016, 04:40 PM
shirleyxls Re: Workbook Open and... 06-16-2016, 05:54 PM
brucemc777 Re: Workbook Open and... 06-17-2016, 11:00 AM
  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    615

    Workbook Open and Activate not functioning

    Running 2016. Today two changes that I know of occurred: W10 upgraded to 160610-1700 and I installed the Dropbox client.

    Either today or yesterday, after a Windows update and restart (I believe another occurred yesterday of some type), for some time (perhaps 10 minutes) I could not access any Office program - any attempt resulted in a window stating that Office was busy, I believe running updates.

    Coincidentally I now find my Workbook_Open event, Workbook_Activate event and WorkSheet_Activate events are not running.

    I checked Application.EnableEvents, setting that to True on WorkBook_BeforeClose (which I verified runs with a messagebox planted in it), then after opening the workbook again I simply checked the status of EnableEvents in the immediate window, verified True.

    I have verified WorkBook_Open is not running with both Stop and Msgbox commands.

    I have further run a complete reboot (btw, after the recent Windows "upgrade" the Start menu refused to come up so I had to nuke the computer (OFF switch)).

    Anything else I can check?

    Anything else that could cause this behavior?

    Edit: Just went to another networked computer that had not had the updates nor DropBox run on it and the workbook ran fine from it. Going to uninstall Dropbox and see if that has any affect on this computer-

    Yet another edit: I don't get it. I uninstalled DropBox and the events ran correctly. I did a reboot, all still good. I reinstalled Dropbox and still the events ran fine. Then I did a reboot and the events would NOT run. Last, I ran an uninstall of DropBox (including registry entries via IOBit's "PowerUninstall). Once uninstalled, without reboot, the events in Excel were running once again.

    Just now an FYI for anyone else out there-
    Last edited by brucemc777; 06-16-2016 at 05:50 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to activate an open Workbook with a variable
    By msf013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2014, 01:53 PM
  2. Activate another open workbook and sheet
    By DFrank231 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2013, 11:14 AM
  3. [SOLVED] Activate an open workbook
    By jimbolhp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2012, 03:00 PM
  4. Activate Open Workbook
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2010, 11:42 PM
  5. Activate sheet after open workbook?
    By proepert in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2010, 08:22 AM
  6. Need to activate an open workbook
    By TrafficGuy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2008, 04:52 PM
  7. how to Activate the previous Open, workbook..?
    By acegap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2006, 11:20 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