+ Reply to Thread
Results 1 to 2 of 2

Selecting Sheets

  1. #1
    Registered User
    Join Date
    01-11-2005
    Posts
    1

    Selecting Sheets

    I am looking to write a Macro that selects all the sheets in a given workbook and sets their Zoom to 100%. This is what I tried thus far, but for somereason, this only works on the first sheet of any given workbook, it doesn't run on the rest of the sheets. Any help is appreciated.

    Sub ZoomReduce()
    For Each sht In Sheets
    ActiveWindow.Zoom = 100
    Next sht
    End Sub

  2. #2
    Forum Contributor
    Join Date
    11-09-2004
    Posts
    451
    Sub ZoomReduce()
    For Each sht In Sheets
    sht.Select
    ActiveWindow.Zoom = 200
    Next sht
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1