Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet navigator
I have a large sheet (80 columns,160 rows) which probably don't fit in user screen , so i want something to work as navigator to the sheet. I thought probably a modeless userform with small sheet preview inside it .. If that's possible then after clicking to the desired area (in the userform of course) the sheet can scroll in that area (probably with cell select or scroll). Can this be done ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet navigator
I realize I might sound a little dense, but I'll risk it: what's wrong with
the built-in scroll bars in Excel? It seems best to me when you stick with what the user already knows about and is familiar with; when you try to re-invent the wheel it costs time and money and rarely works well. You can provide a little bit of navigational aid by placing blank columns so they can scroll quickly left and right with ctrl-{right arrow} and ctrl-{left arrow}. This key sequence will move to the end of the current area, so a blank column is a "stopping point." Another useful (and also built-in) feature is the split scrolling feature, which allows column and row headers to stay put while scrolling, which can also be helpful for users. (Look up "Panes" in the online help for more info on this feature). -- HTH - -Frank Microsoft Excel MVP Dolphin Technology Corp. http://vbapro.com "GUS" wrote in message ... I have a large sheet (80 columns,160 rows) which probably don't fit in user screen , so i want something to work as navigator to the sheet. I thought probably a modeless userform with small sheet preview inside it . If that's possible then after clicking to the desired area (in the userform of course) the sheet can scroll in that area (probably with cell select or scroll). Can this be done ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet navigator
-----Original Message----- I have a large sheet (80 columns,160 rows) which probably don't fit in user screen , so i want something to work as navigator to the sheet. I thought probably a modeless userform with small sheet preview inside it .. If that's possible then after clicking to the desired area (in the userform of course) the sheet can scroll in that area (probably with cell select or scroll). Can this be done ? You may want to consider using hyperlinks to specific cells in your worksheet. You could add another worksheet and place the links and a description of each link's destination on that worksheet. You can use the Workbook_Open event to activate your hyperlink worksheet first. This method is much more stable and easier to maintain than a form. Diane Meade |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Navigator Window for Excel Speadsheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
How do I widen the Name Box Navigator in Excel? | Excel Worksheet Functions |