+ Reply to Thread
Results 1 to 5 of 5

Screen position of cell

  1. #1
    Registered User
    Join Date
    01-27-2008
    Posts
    6

    Screen position of cell

    Help please,
    Following an insertion of a hyperlink to an off screen distant cell, is it possible to force the accessed cell to appear at (eg) the top left of monitor screen? Would it be any different if using different worksheets rather than a single sheet?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    There are macros that can activate when you use hyperlinks
    Check out this example when you click on the banana hyperlink this code kicks in:
    Please Login or Register  to view this content.
    This code goes into a regular module
    Please Login or Register  to view this content.
    this goes into the worksheet module
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by davesexcel; 01-27-2008 at 01:08 PM.

  3. #3
    Registered User
    Join Date
    01-27-2008
    Posts
    6
    Thanks but that was not quite what I was trying to achieve. I want the "existing" part of the sheet to dissapear and the "new" part to show as a whole screen view with the target cell at a fixed part of the screen, like a new page of a book.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello TonyW2,

    Add this macro to each worksheet in your workbook that has hyperlinks.
    Please Login or Register  to view this content.
    How to Save a Worksheet Event Macro
    1. Copy the macro using CTRL+C keys.
    2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
    3. Left Click on View Code in the pop up menu.
    4. Paste the macro code using CTRL+V
    5. Save the macro in your Workbook using CTRL+S

    Sincerely,
    Leith Ross

  5. #5
    Registered User
    Join Date
    01-27-2008
    Posts
    6
    Thank you. That was exactly what I needed, and the instructions were comprehendable even by me!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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