Vikki_61
12-07-2007, 04:01 AM
HI VBA community
What I have is a interesting task but unfortunity I am well
out of my Depth :dunno so if you can help that would be GREAT.:rotlaugh:
Attached is my excel dashboard report framework. What would be real nice
for this are three things
1. PREVENT USER SCROLLING: Some VBA code for the workbook that for all worksheets stops users from scolling outside of the set print area
once it is set on.
2. AUTO RANKING DISPLAY: For the Ranking display on the Dashboard
Worksheet 1 put the text from
worksheet 2 column B rows 5 to 12 in order of their percentage
in column I of worksheet 2 into Ranking Display on worksheet 1
in column I rows 21,23,25,27,29,31,and 33.(1st to 8th).With
the highest percentage being 1st and the lowest last -and incase
two percentages are the same allow for that (one could just be before
the other -that wouldnt matter so long as the code still worked) and as
the percentage in worksheet 2 changes so would the ranking auto update.
3. A DROPDOWN SELECTION:I have placed some hyperlinks on DASHBOARD worksheet1 however I think it would be nicer and if there was a dropdown list of the tabs to choose from a dropdown of all tabs from worksheet 2 to worksheet 9 with the name of those worksheets in the drop down. Then once selected it will go straigth there with no further interaction from the user.
My Dashboard demo test file is attached
Hope someone would like to help. Thanks in advance :cloud9:
Regards
Vikki_61
What I have is a interesting task but unfortunity I am well
out of my Depth :dunno so if you can help that would be GREAT.:rotlaugh:
Attached is my excel dashboard report framework. What would be real nice
for this are three things
1. PREVENT USER SCROLLING: Some VBA code for the workbook that for all worksheets stops users from scolling outside of the set print area
once it is set on.
2. AUTO RANKING DISPLAY: For the Ranking display on the Dashboard
Worksheet 1 put the text from
worksheet 2 column B rows 5 to 12 in order of their percentage
in column I of worksheet 2 into Ranking Display on worksheet 1
in column I rows 21,23,25,27,29,31,and 33.(1st to 8th).With
the highest percentage being 1st and the lowest last -and incase
two percentages are the same allow for that (one could just be before
the other -that wouldnt matter so long as the code still worked) and as
the percentage in worksheet 2 changes so would the ranking auto update.
3. A DROPDOWN SELECTION:I have placed some hyperlinks on DASHBOARD worksheet1 however I think it would be nicer and if there was a dropdown list of the tabs to choose from a dropdown of all tabs from worksheet 2 to worksheet 9 with the name of those worksheets in the drop down. Then once selected it will go straigth there with no further interaction from the user.
My Dashboard demo test file is attached
Hope someone would like to help. Thanks in advance :cloud9:
Regards
Vikki_61