Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move cursor to A1 in all worksheets, relocate A1 to top right, sav
Is there a macro out there that performs these functions?
1. groups all worksheets in a workbook, 2. moves cursor to A1, 3. relocates A1 to top right of screen, 4. changes all pages to normal view, 5. Ungroups worksheets, and 6. Saves file |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move cursor to A1 in all worksheets, relocate A1 to top right, sav
This should be close...
Sub FormatSheets() Dim wks As Worksheet For Each wks In Worksheets If wks.Visible = xlSheetVisible Then wks.Select With wks.Range("A1") .Select .Show End With ActiveWindow.View = xlNormalView End If Next wks ThisWorkbook.Save End Sub -- HTH... Jim Thomlinson "Emangino" wrote: Is there a macro out there that performs these functions? 1. groups all worksheets in a workbook, 2. moves cursor to A1, 3. relocates A1 to top right of screen, 4. changes all pages to normal view, 5. Ungroups worksheets, and 6. Saves file |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move cursor on one sheet moves cursor on all sheets | Excel Discussion (Misc queries) | |||
Move cursor to next row | Excel Discussion (Misc queries) | |||
move cursor | Excel Programming | |||
Move Cursor to A1 | Excel Discussion (Misc queries) | |||
HOW TO MOVE CURSOR | Excel Programming |