Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a series of worksheets in a single workbook. I'd like to have
them display showing the top (cell A1) of the sheet when the workbook is opened. I already have an Auto Open macro to remove previously applied filters and other stuff. I put in the following to get the top of the sheet to show on opening: ..LargeScroll Down:=-10 This just scrolls up (not sure why "Down" is up?) on each sheet. But it only works because the sheets are relatively short. I'd have to use -100 or -1000 on larger sheets, then test to see if it worked. Is there a simpler way of having each sheet display from the top on opening? Thanks to all! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command Button to show/hide a different worksheet | Excel Discussion (Misc queries) | |||
How do I find in Excel 2007 the Command Show Outline Symbols | Excel Worksheet Functions | |||
How do I show toolbar command titles when pointing at the icons? | Excel Discussion (Misc queries) | |||
How the XML command show on the Data menue on my Excel 2003 | Setting up and Configuration of Excel | |||
On my data menu, my list command does not show | Excel Discussion (Misc queries) |