Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Carson City, Nevada, USA
    Posts
    46
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Determining Zoom Percentage (2000, SP-3)

    Could one of you tell me how, in a VBA macro, I can determine the screen zoom percentage. I am not interested in the print zoom, only the display? I have searched here and on a couple of other sites (Pearson's for one) and can't find what I am looking for. the MSExcel VBA help only addresses the print zoom....

    Thanks in advance...

  2. #2
    Star Lounger
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Determining Zoom Percentage (2000, SP-3)

    Hi Robbie,

    Sub Macro1()
    MsgBox ActiveWindow.Zoom
    End Sub

    If you want to find out those kind of things, it is always a good idea to use the Macro recorder.
    Recording e.g. the change of your zoom from 100 to 75, the resulting code may give you an idea what the correct command could be.

    Best regards

    Wolf

  3. #3
    Lounger
    Join Date
    Nov 2001
    Location
    Carson City, Nevada, USA
    Posts
    46
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Determining Zoom Percentage (2000, SP-3)

    Thanks Wolf, that did give me the command I needed. I swear that I tried that but I guess I did it wrong!!!!

Posting Permissions

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