+ Reply to Thread
Results 1 to 5 of 5

Move Ctrl + F6 or make a macro that mimicks what Ctrl + F6 does

  1. #1
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Move Ctrl + F6 or make a macro that mimicks what Ctrl + F6 does

    Hi

    I don't consider Ctrl + F6 (switch to next window, like Ctrl + Tab in Excel) to be a one hand operation. A shortcut that requires two hands is not a good shortcut.

    Is it possible to move the Ctrl + F6 to another button? My guess is no but I'm asking anyway, just in case.

    In that case I need help with a macro that mimicks the Ctrl + F6 behaviour. I tried and I got this far:
    Please Login or Register  to view this content.
    It works as long as a window is not minimized. I like to think that I could figure this out on my own by the end of the day (and possibly night). I also like to believe that there is someone here on the forum that can have this code working in no time.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Move Ctrl + F6 or make a macro that mimicks what Ctrl + F6 does

    Put this into your personal workbook

    use ctrl e to go to next window.

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Move Ctrl + F6 or make a macro that mimicks what Ctrl + F6 does

    Hello mehmetcik

    This code only produces an error message:
    "Compile error: Method or data member not found"

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Move Ctrl + F6 or make a macro that mimicks what Ctrl + F6 does

    Ctrl-F6 and Alt-F6 both switch document windows. I can use either combo with one hand...

    You could use:
    Please Login or Register  to view this content.
    Alternatively, if you have a programmable mouse with an extra button, you may be able to use its config app to use that button for toggling the windows.
    Last edited by macropod; 08-14-2014 at 10:06 AM.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  5. #5
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Move Ctrl + F6 or make a macro that mimicks what Ctrl + F6 does

    Yup, that seems to work.
    Thanks for the help macropod, I appreciate it!

+ 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. Help needed : Unable to use CTRL+C or CTRL+D to copy formula
    By Elangovan89 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-09-2014, 10:20 AM
  2. Replies: 3
    Last Post: 08-02-2013, 12:06 PM
  3. Ctrl+pg up and Ctrl+pg Down Dont work, New & unprotected documents
    By desert_dweller5 in forum Excel General
    Replies: 2
    Last Post: 09-10-2012, 07:44 AM
  4. ctrl c and ctrl v breaks a merge cell
    By eg_ckhad in forum Excel General
    Replies: 1
    Last Post: 07-28-2008, 12:41 AM
  5. [SOLVED] Macro's with Ctrl or Ctrl-Shift?
    By Al Franz in forum Excel General
    Replies: 6
    Last Post: 09-05-2005, 06:05 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