Consulting

Results 1 to 5 of 5

Thread: Solved: Worksheet Zoom property

  1. #1
    VBAX Tutor SJ McAbney's Avatar
    Joined
    May 2004
    Location
    Glasgow
    Posts
    243
    Location

    Solved: Worksheet Zoom property

    How do I obtain the Zoom property of a worksheet?

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    [vba]
    ActiveWindow.Zoom = 150
    [/vba]

    or

    [VBA]
    x = ActiveWindow.Zoom
    [/VBA]

  3. #3
    VBAX Tutor SJ McAbney's Avatar
    Joined
    May 2004
    Location
    Glasgow
    Posts
    243
    Location
    Thanks. I just found it myself.

    This is one of the last few things for my first version of my worksheet manager.

    What do you think?

  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Looks nice

    I would add the <,> signs to the buttons.

    << First
    < Previous
    Next >
    Last >>

    So are you gonna post that to the kb?

  5. #5
    VBAX Tutor SJ McAbney's Avatar
    Joined
    May 2004
    Location
    Glasgow
    Posts
    243
    Location
    I don't know what I'm going to do yet.

    I want to create my own little suite of add-ins and applications that will help people with VB and VBA and making things easier in the Office applications.

    Once I get my VB/VBA site (more for the sale of small handy addins, ActiveX controls, etc) for nominal prices I'll know better what I want to do with it.

Posting Permissions

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