+ Reply to Thread
Results 1 to 3 of 3

Workbook Open and Activate not functioning

Hybrid View

  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.

  2. #2
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Workbook Open and Activate not functioning

    Might be worth checking on answers.microsoft.com - I had the problem with the start button not working a while ago and I seem to remember there was some mention of dropbox causing a problem so may be worth taking a look. You may also find other people on there who are having similar Excel problems to yours since the latest update.

    I was one of the lucky ones and managed to roll back my Windows 10 install to Windows 8 when MS couldn't seem to come up with a sensible solution to the start button issue!
    Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.

  3. #3
    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

    Re: Workbook Open and Activate not functioning

    Interesting - I never browsed those before... Only annoyance was that dang "cookies warning" thanks to your neighbors to the south!

+ 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. 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