+ Reply to Thread
Results 1 to 7 of 7

Need activated cell ("bookmark") to be force to the top of the screen

  1. #1
    Forum Contributor
    Join Date
    08-06-2018
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    333

    Need activated cell ("bookmark") to be force to the top of the screen

    Experts:

    I created a "Dashboard" in Excel... overall I'm very happy w/ the product. However, I need some assistance with potentially tweaking the VBA below.

    Background:
    - I have "frozen" the first 3 rows.
    - In rows 1:3, I have placed nine (9) command buttons that serve as a "bookmark" (see VBA below).
    - While the VBA code works as envisioned. That is, either cell B5 (via cmdButton1) or B122 (via cmdButton4) is highlighted/
    Please Login or Register  to view this content.
    What I Need Some Help With:
    - When clicking at, e.g., cmdButton4, not only do I want the cell to be activated (which it currently is), I also want that cell to be at the top of the screen.
    - Again, my 1st three rows are frozen (I call this my header section with the logo and command buttons).
    - So, I'd like that "bookmark" to be right underneath the header section (below row 3). At this time, however, the activated cell does NOT do that.
    - Instead, I must scroll down to see the entire section where I keep slicers/graphs for that section.

    My Question:
    Is there a way (via VBA) to force the activated cell to the top of the screen (below my frozen rows)?

    Thank you,
    EEH
    Last edited by skydivetom; 11-25-2020 at 08:41 AM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Need activated cell ("bookmark") to be force to the top of the screen

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-06-2018
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    333

    Re: Need activated cell ("bookmark") to be force to the top of the screen

    Fluff13:

    I get the following error:

    Run-time error '1004':
    Method 'Goto' of object _Application failed

  4. #4
    Forum Contributor
    Join Date
    08-06-2018
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    333

    Re: Need activated cell ("bookmark") to be force to the top of the screen

    I just came across a solution (see VBA below); however, I don't like the way it looks:

    Please Login or Register  to view this content.
    Additional info:
    - I added the code into a module and then call the function from within the worksheet
    - This one requires the active cell to be in column A (vs. column B).
    - Now, while it works, the "image" that I currently have in column A has the green cell border (active cell) around it

    My questions:
    Is there to "de-activate" the cell **after** is was a) activated and b) then moved up? So, c) would be = deactivate cell

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Need activated cell ("bookmark") to be force to the top of the screen

    I get the following error:
    Can you supply a sample workbook, that replicates that problem.

  6. #6
    Forum Contributor
    Join Date
    08-06-2018
    Location
    Virginia
    MS-Off Ver
    2019
    Posts
    333

    Re: Need activated cell ("bookmark") to be force to the top of the screen

    Fluff13:

    I just figure it out... I used the code as provided previously.

    Then, however, I activate the last row on the bottom of the sheet... this selection of the cell is unbeknownst to the user.

    I thank you for sharing your ideas with me... 'truly appreciate it.

    Cheers,
    Tom

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Need activated cell ("bookmark") to be force to the top of the screen

    Glad you sorted it & thanks for the feedback.

+ 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] Open Workbook in "Full Screen" mode but with sized "Window" View
    By HGL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2016, 05:54 AM
  2. [SOLVED] Force "Read Only" only in original spreadsheet - NOT in resultant "saved as" spreadsheets
    By xdrenched in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2016, 01:11 PM
  3. [SOLVED] FORCE Excel to stay in "Full Screen" mode
    By ericbartha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2015, 02:19 PM
  4. [SOLVED] Possible to "gray out" or not include a cell value until activated?
    By johnny206 in forum Excel General
    Replies: 7
    Last Post: 01-31-2014, 03:17 PM
  5. Excell - How do I "force" cell to be filled or return error mge.
    By NeedHelp-Thanks! in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  6. [SOLVED] Excell - How do I "force" cell to be filled or return error mge.
    By NeedHelp-Thanks! in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] Excell - How do I "force" cell to be filled or return error mge.
    By NeedHelp-Thanks! in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11: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