+ Reply to Thread
Results 1 to 4 of 4

Set Zoom Level Input Box

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    547

    Set Zoom Level Input Box

    Hi All, how do i create in input box to select zoom level for this code. If anyone has a second and can help I woudl be very greatfull.



    Sub ZoomAll()
     
    Dim ws As Worksheet
     Application.ScreenUpdating = False
       
    For Each ws In Worksheets
     If InStr(ws.Name, "_") > 0 And ws.Visible = True Then
        
        
        ws.Activate
     
        ActiveWindow.Zoom = 55
     
    End If
    Next ws
    
    End Sub

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Set Zoom Level Input Box

    How about this?
    Sub ZoomAll()
        Dim ws As Worksheet
        Dim zoomlevel As Integer: zoomlevel = InputBox("Enter Zoom Level : ", "")
        
        Application.ScreenUpdating = False
        For Each ws In Worksheets
            If InStr(ws.Name, "_") > 0 And ws.Visible = True Then
                ws.Activate
                ActiveWindow.Zoom = zoomlevel * 1
            End If
        Next ws
        Application.ScreenUpdating = True
    End Sub
    BSB

  3. #3
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    547

    Re: Set Zoom Level Input Box

    Thank you kindly.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Set Zoom Level Input Box

    Happy to help

    BSB

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Default Zoom Level for new workbooks and sheets
    By kersplash in forum Excel General
    Replies: 4
    Last Post: 02-09-2018, 05:05 AM
  2. Set Zoom Level with CreateObject
    By swatsp0p in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2015, 03:44 PM
  3. Protected Zoom Level for all sheets for all users
    By bga1nz in forum Excel General
    Replies: 7
    Last Post: 12-22-2013, 07:29 PM
  4. [SOLVED] Cell return tab zoom level?
    By Environment in forum Excel General
    Replies: 5
    Last Post: 09-04-2012, 12:29 PM
  5. [SOLVED] Zoom level
    By Fotis in forum Excel General
    Replies: 1
    Last Post: 07-07-2006, 11:45 AM
  6. Zoom Level Affecting Formatting
    By J Cope At Stratis in forum Excel General
    Replies: 1
    Last Post: 05-11-2006, 06:22 PM
  7. Setting Default Zoom Level?
    By Jim in forum Excel General
    Replies: 1
    Last Post: 05-04-2006, 05:55 PM

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