Results 1 to 4 of 4

Thread: Annoying Excel 2019 Habit

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Annoying Excel 2019 Habit

    In Excel 2019 with both the Excel and VBA window open, if I pass my cursor over the VBA window on my way to a worksheet, I'm annoyingly taken to VBA.

    In Excel 2010 that didn't happen. Is there some way to prevent it from happening in 2019?

  2. #2
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,392

    Re: Annoying Excel 2019 Habit

    I'm annoyingly taken to VBA.
    Are you saying that when you pass the mouse pointer over the VBA editor window, it automatically gets the focus without clicking anywhere on it, and then when the mouse cursor reaches the Excel window, the VBA window still has the focus? I am not seeing that with Excel 2016. I will have to try it with 2019 to see what happens.

  3. #3

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: Annoying Excel 2019 Habit

    Here is a picture of the situation.
    Name:  2022-06-27_09-37-51.jpg
Views: 104
Size:  29.5 KB
    If I'm editing and I click the 'View Microsoft Excel' button, it takes me to the Excel window, but if I move my cursor down from anywhere above the top of the VBA window and it encounters the macro code, I'm taken there.

  4. #4
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    4,415

    Re: Annoying Excel 2019 Habit

    Confirmed behaviour in O365
    Never noticed it, since when i'm in the VBA-Editor (ALT+F11) i never hit that combination again
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

Posting Permissions

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



Click Here to Expand Forum to Full Width