Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Adding second scroll bar

Posted on 2014-09-02
11
Medium Priority
?
91 Views
Last Modified: 2014-09-02
Folks,
Kindly, one of the EE folks created a way to scroll through cells. My workbook has two areas - Category and Topics. In the Topics area is where scrolling occurs. I find myself needing the same functionality for Category and my efforts have FAILED. Help would be appreciated.
Excel-Dashboards-Rev-Test.xlsm
0
Comment
Question by:Frank Freese
  • 6
  • 5
11 Comments
 
LVL 50

Expert Comment

by:Martin Liss
ID: 40299719
I'm on it.
0
 
LVL 50

Expert Comment

by:Martin Liss
ID: 40299728
Will you have more than 21 Categories?
0
 

Author Comment

by:Frank Freese
ID: 40299805
I'm trying to consolidate down to 30, so year, more than 21
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:Frank Freese
ID: 40299826
s/b/ yes
0
 
LVL 50

Accepted Solution

by:
Martin Liss earned 2000 total points
ID: 40299884
Try this. The hardest part was the addition of an extra column between Category and Topics which of course pushed Topics and Description one column to the right. The reason that was a problem was because there were a number of places where columns "C" and "F" were hard-coded into Range() statements and "3" and "6" were hard-coded into Cells() statements as column number references and all of them and some other variations had to be changed, making sure that the few places in the code for some of the unaffected detail sheets were not changed. Since there aren't enough Topics for any Category in this workbook to make Topics scroll, that something you should test later on to make sure it still works.
Q-28510163.xlsm
0
 

Author Comment

by:Frank Freese
ID: 40299959
Workbook crashed when I opened it. See below:
errorcodeThanks
Frank
0
 
LVL 50

Expert Comment

by:Martin Liss
ID: 40299966
It works fine when I open it. Close Excel and try again. If that doesn't work then reboot.
0
 

Author Comment

by:Frank Freese
ID: 40299985
OK...let's see what happens.
0
 

Author Comment

by:Frank Freese
ID: 40300007
You nailed it!
Thanks
0
 

Author Closing Comment

by:Frank Freese
ID: 40300009
Thank you very much
0
 
LVL 50

Expert Comment

by:Martin Liss
ID: 40300077
YW
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question