+ Reply to Thread
Results 1 to 2 of 2

Dynamic link to cell for ThisWorkbook.Sheets fucntion

  1. #1
    Registered User
    Join Date
    11-18-2020
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    1

    Dynamic link to cell for ThisWorkbook.Sheets fucntion

    I am trying to create a dynamic menu to sit on the left of every sheet in a workbook, which there are about 20. I have created the following for code, which works, if I have hard coded thhe destination.

    ThisWorkbook.Sheets("sheet3").Activate

    However I wanted the "sheet3" to be driven from a cell in a different "setup_sheet", this way I can change the setup_sheet and it filter through to the code. I had tried

    ThisWorkbook.Worksheet("setup_sheet").Range("A1").Activate, but i reliase this is not right, but wanted to show I had tried

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Dynamic link to cell for ThisWorkbook.Sheets fucntion

    in a nut shell you would want

    ThisWorkbook.Worksheet(sheets("setup_sheet").Range("A1")).Activate
    you will need ways to stop it bugging out though
    ie if you put type sheetname that doesnt exist or spell it wrong etc
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Dynamic link dependent on cell contents
    By DarrylBurge in forum Office 365
    Replies: 2
    Last Post: 05-01-2020, 10:16 AM
  2. [SOLVED] For...next and thisworkbook.sheets error
    By Tpleme in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-05-2018, 09:47 AM
  3. Access Dynamic Array from ThisWorkBook to Sheet1
    By broro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 07:04 PM
  4. Dynamic externa cell link
    By a94andwi in forum Excel General
    Replies: 1
    Last Post: 05-12-2010, 06:28 AM
  5. link dynamic data to cell?
    By Theguyfromnj in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-12-2006, 08:20 AM
  6. Replies: 0
    Last Post: 06-26-2006, 09:40 PM
  7. [SOLVED] Dynamic link a cell to a worksheet tab
    By Genesis in forum Excel General
    Replies: 9
    Last Post: 02-20-2006, 03:55 AM

Tags for this Thread

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