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/
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
Bookmarks