+ Reply to Thread
Results 1 to 4 of 4

Problem with ActiveSheet VBA code when it is the open but not in focus

  1. #1
    Forum Contributor
    Join Date
    11-08-2014
    Location
    UK
    MS-Off Ver
    Office 2013
    Posts
    208

    Problem with ActiveSheet VBA code when it is the open but not in focus

    My worksheet contains VBA to control the order of tabbing. It activates when sheet is activesheet and disables when it's not. The problem I encountered today, is that I switched to another application, tried to tab and it was trying to open up the workbook containing the tab controlled worksheet.

    Is there anything I can do about this?

    https://docs.google.com/spreadsheets...f=true&sd=true

    Thanks for your help.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,186

    Re: Problem with ActiveSheet VBA code when it is the open but not in focus

    Please post your code and, ideally, upload the workbook, not a link.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    11-08-2014
    Location
    UK
    MS-Off Ver
    Office 2013
    Posts
    208

    Re: Problem with ActiveSheet VBA code when it is the open but not in focus

    ThisWorkbook:

    Please Login or Register  to view this content.
    Clipboard Worksheet
    Please Login or Register  to view this content.
    Clipboard Module
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-08-2014
    Location
    UK
    MS-Off Ver
    Office 2013
    Posts
    208

    Re: Problem with ActiveSheet VBA code when it is the open but not in focus

    Attached as requested.

+ 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. [SOLVED] ActiveSheet Unprotect to Userform open, and ActiveSheet Protect to Userform close
    By chrismil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2020, 06:30 AM
  2. [SOLVED] Set Focus on form at workbook open
    By rob_h in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-17-2017, 12:14 PM
  3. [SOLVED] Worksheet focus problem, how do I set focus?
    By MichiganWilliams in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2014, 03:04 PM
  4. Returning focus to a browser tab that is already open?
    By XmisterIS in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-04-2014, 03:38 AM
  5. [SOLVED] How to get a macro to open file using activesheet path
    By mbroxholme in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-16-2013, 10:31 AM
  6. [SOLVED] Why are my inserted photos out of focus when I open excel?
    By lakrueger in forum Excel General
    Replies: 0
    Last Post: 09-23-2005, 07:05 PM
  7. tool tip to open when the cell has the focus
    By GRIFFO in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-19-2005, 04:06 PM

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