Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I am trying to reset the following for each worksheet in the workbook; however am getting errors on the "Window.View = xlNormalView" (I am am trying to learn the Object Model)Similar iss below w/ resetting pointer Reset "Page Break Preview" for each worksheet in the workbook; so view is set to "Normal" on each worksheet Sub Set_Page_Preview_Normal() For Each wks In Worksheets Window.View = xlNormalView Next wks End Sub ' Reset Cell pointer in worksheet so view is at top of page on each worksheet Sub Set_Cell_Pointer_A1() For Each wks In Worksheets wks.Range("A1").Select Next wks End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tab Key reset | Excel Worksheet Functions | |||
set Print Preview to "preview" page that was being worked on? | Excel Discussion (Misc queries) | |||
How do I reset the tab key? | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
set or reset the print range for several sheets at a time? | Excel Discussion (Misc queries) |