Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How could the sub below be generalized to work on all simultaneously open
books and views (I may have some books open with multiple windows)? The sub currently works only on the activebook/view (where the cursor is). Thanks Sub NoGridLinesZoom75() Dim ws As Worksheet Dim wsht As Worksheet Set wsht = ActiveSheet For Each ws In ActiveWorkbook.Worksheets ws.Activate ActiveWindow.DisplayGridlines = False ActiveWindow.Zoom = 75 Next wsht.Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
How to generalize sorting range in macro??? | Excel Programming | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Work books | Excel Worksheet Functions |