| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll to top of page code
Public Sub Worksheet_Activate()
Application.ScreenUpdating = False Password = "djdog" ActiveSheet.Unprotect Password Cells.Select Selection.EntireRow.Hidden = False Application.Goto Reference:=Range("A7"), Scroll:=True Peter, I don't know for sure, but I'd think turning off ScreenUpdating is keeping your original code from working. I've never needed to keep the screen from updating while using my code. Norman's code forces the scrolling where your original code (and mine) do not. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you have the headings scroll down the page as you move dow | Excel Worksheet Functions | |||
| How do I get my arrows to scroll the cells not the page? | Excel Discussion (Misc queries) | |||
| how to have my titles move down as i scroll down the page | Excel Discussion (Misc queries) | |||
| Moving Page with Scroll Bar | Excel Discussion (Misc queries) | |||
| VBA code to scroll all the way to the top | Excel Programming | |||
Threaded Mode
