+ Reply to Thread
Results 1 to 3 of 3

Is there vba code which can disable/enable switching between open workbooks

  1. #1
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Is there vba code which can disable/enable switching between open workbooks

    Hi all,

    I have some code which after being run seems to disable the ability to switch between open excel workbooks either via alt-tabbing or clicking on a non active workbook from the windows taskbar.

    I'm hoping to find some code which will enable this ability again to use as normal.

    If i click on the restore windows button (button left of the lower close windows button) in the active workbook i can then see and switch between open workbooks.

    Any ideas?

  2. #2
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: Is there vba code which can disable/enable switching between open workbooks

    i'd prefer to not paste in the code as it runs into the hundreds of lines and will save me from editing out sensitive code

  3. #3
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Re: Is there vba code which can disable/enable switching between open workbooks

    anyone?

+ 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] Switching Between two open Workbooks
    By Bobbbo in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-26-2020, 09:33 PM
  2. VBA Code to Know Macro Enable or Disable when Open workbook
    By GOLDENEXCEL in forum Excel General
    Replies: 3
    Last Post: 10-09-2015, 08:52 AM
  3. Switching between workbooks open in different instances
    By GerPis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2015, 11:03 AM
  4. enable/disable stuff on open/close
    By sabha in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-19-2014, 02:26 AM
  5. [SOLVED] Switching Between Open Workbooks In VBA
    By ajocius in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2012, 05:14 AM
  6. Switching between open workbooks
    By Sam_Gregson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2009, 05:58 AM
  7. Switching Between Open Workbooks in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 10-31-2007, 04:35 AM

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