+ Reply to Thread
Results 1 to 6 of 6

Macro to Focus on Worksheet

  1. #1
    Registered User
    Join Date
    08-11-2009
    Location
    Lancashire England
    MS-Off Ver
    Excel 2007
    Posts
    34

    Macro to Focus on Worksheet

    Hi

    I want to select a cell containing the 'name' of another sheet within the same workbook. To activate the macro, which will then focus on the 'name' worksheet!

    Many thanks for any help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to Focus on Worksheet

    Try this too see if it does what you want.

    Or you can do it with a button.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-11-2009
    Location
    Lancashire England
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: Macro to Focus on Worksheet

    Hi, thanks! I realise now that my actual problem is more complex, please see attached extract of my actual worksheet?

    Many thanks
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to Focus on Worksheet

    Does this help?

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-11-2009
    Location
    Lancashire England
    MS-Off Ver
    Excel 2007
    Posts
    34

    Thumbs up Re: Macro to Focus on Worksheet

    Hi

    Thank you, that's great!
    Kind regards Rob

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to Focus on Worksheet

    You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as SOLVED.

+ 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] Worksheet focus always when using a userform
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2014, 06:37 PM
  2. [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
  3. [SOLVED] Moving to another worksheet without losing focus
    By navbor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2012, 04:48 PM
  4. Keep focus on Same Worksheet
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-20-2010, 10:06 AM
  5. Returning focus to the worksheet
    By Neil Ives in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2009, 09:39 AM
  6. Worksheet Focus
    By Zani in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-16-2006, 04:00 PM
  7. [SOLVED] Set Focus to Worksheet and then a specific ROW
    By HotRod in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2005, 12:35 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