Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting scrollbar inside an Excel Sheet
Hello!
I have a need to insert to scrollbar inside an existing Excel tab due to a huge amount of column.. I know how to insert the scrollbar but I don't have any clue as to make it so it'll scroll left/right. For instance, column A - D will be stagnate because I need them for headers and title. I would like column E-IV to scroll left or right based on the embeded scrollbar. I know I can do a freeze pane but I don't like the look of the splitting line as I already have a horizontal split already. Any thoughts will be appreciated. Lee |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting scrollbar inside an Excel Sheet
Insert code in a regular module
Sub sCroll() Application.ScreenUpdating = False Range("E1:IV1").Select Selection.EntireColumn.Hidden = True Range(Cells(1, [a1]), Cells(1, [a1] + 9)).EntireColumn.Hidden = False Cells(1, 1).Select Application.ScreenUpdating = True End Sub From Formulamenu, insert a scroll-bar link the bar to sCroll macro Rightclick on sCrolbar and set Min value to 5 and max value to 255 make cell A1 the linking cell +9 in the code is count of colums to show - change to fit "Genesis" skrev: Hello! I have a need to insert to scrollbar inside an existing Excel tab due to a huge amount of column.. I know how to insert the scrollbar but I don't have any clue as to make it so it'll scroll left/right. For instance, column A - D will be stagnate because I need them for headers and title. I would like column E-IV to scroll left or right based on the embeded scrollbar. I know I can do a freeze pane but I don't like the look of the splitting line as I already have a horizontal split already. Any thoughts will be appreciated. Lee |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting scrollbar inside an Excel Sheet
On Oct 22, 1:29 pm, excelent
wrote: Insert code in a regular module Sub sCroll() Application.ScreenUpdating = False Range("E1:IV1").Select Selection.EntireColumn.Hidden = True Range(Cells(1, [a1]), Cells(1, [a1] + 9)).EntireColumn.Hidden = False Cells(1, 1).Select Application.ScreenUpdating = True End Sub From Formulamenu, insert a scroll-bar link the bar to sCroll macro Rightclick on sCrolbar and set Min value to 5 and max value to 255 make cell A1 the linking cell +9 in the code is count of colums to show - change to fit "Genesis" skrev: Hello! I have a need to insert to scrollbar inside an existing Excel tab due to a huge amount of column.. I know how to insert the scrollbar but I don't have any clue as to make it so it'll scroll left/right. For instance, column A - D will be stagnate because I need them for headers and title. I would like column E-IV to scroll left or right based on the embeded scrollbar. I know I can do a freeze pane but I don't like the look of the splitting line as I already have a horizontal split already. Any thoughts will be appreciated. Lee- Hide quoted text - - Show quoted text - LOL.. all sounds Greek to me. I have no idea what you're talking about? are you reffing to add these codes into the VB editor? If so, I'm not well versed in VB and wouldn't know where to begin. If you can show me or possible attached/supply a working excel sample, that would help. Thanks. Lee |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting scrollbar inside an Excel Sheet
http://pmexcelent.dk/myScroll.xls
"Genesis" skrev: On Oct 22, 1:29 pm, excelent wrote: Insert code in a regular module Sub sCroll() Application.ScreenUpdating = False Range("E1:IV1").Select Selection.EntireColumn.Hidden = True Range(Cells(1, [a1]), Cells(1, [a1] + 9)).EntireColumn.Hidden = False Cells(1, 1).Select Application.ScreenUpdating = True End Sub From Formulamenu, insert a scroll-bar link the bar to sCroll macro Rightclick on sCrolbar and set Min value to 5 and max value to 255 make cell A1 the linking cell +9 in the code is count of colums to show - change to fit "Genesis" skrev: Hello! I have a need to insert to scrollbar inside an existing Excel tab due to a huge amount of column.. I know how to insert the scrollbar but I don't have any clue as to make it so it'll scroll left/right. For instance, column A - D will be stagnate because I need them for headers and title. I would like column E-IV to scroll left or right based on the embeded scrollbar. I know I can do a freeze pane but I don't like the look of the splitting line as I already have a horizontal split already. Any thoughts will be appreciated. Lee- Hide quoted text - - Show quoted text - LOL.. all sounds Greek to me. I have no idea what you're talking about? are you reffing to add these codes into the VB editor? If so, I'm not well versed in VB and wouldn't know where to begin. If you can show me or possible attached/supply a working excel sample, that would help. Thanks. Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting time inside cell | New Users to Excel | |||
Inserting time inside cell | Excel Discussion (Misc queries) | |||
VLOOKUP used with Access DB inside of Excel Sheet | Excel Discussion (Misc queries) | |||
scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) | |||
Unlock a spinner or scrollbar on a protected sheet | Excel Worksheet Functions |