Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a macro that protects all sheets (and it does a few other things at
the same time): I would like to include some code that make all the sheets scroll to the top. I tried adding "ws.Range("O1").Select" but that doesn't work. Sub Protect1_Click() For Each ws In Worksheets ws.Range("O29:Z29").Interior.ColorIndex = 2 ws.Shapes("Date Hired").LockAspectRatio = msoFalse ws.Shapes("Date Hired").Height = 28.5 ws.Shapes("Date Hired").Width = 112.5 ws.Shapes("Unprotect1").ZOrder msoBringToFront ws.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True Next End Sub Thanks in advance, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I make the scroll bar show the row number? | Excel Discussion (Misc queries) | |||
no scroll bars or tab sheets | Excel Worksheet Functions | |||
have sheets 2 and 3 scroll the same when scrolling sheet 1? | Excel Discussion (Misc queries) | |||
Can you make all sheets scroll when scrolling one sheet | Excel Worksheet Functions | |||
How do I make a row or information, follow as you scroll down..? | Excel Worksheet Functions |