Weirdness w/Zoom
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Weirdness w/Zoom

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    For some reason, whenever I choose Print Preview, I am unable to zoom on the object. This only happens with one file that I have a ton of VBA on.

    Any suggestions?

    Thanks in advance,
    Patrick

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How big is the page size in page setup? Perhaps it is 11 x 17 or something that is unable to be zoomed in on?

    Just a guess.
    ~Anne Troy

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I checked the printer and paper size. No problem there. It is only happening on this one particular file. Additionally, I am also having a problem with this file when I try to close it. The file will close, but Excel will not. Then, if you try to close Excel again, it says "loading Funcres.xla" in the bottom left hand corner. An error message is generated and Excel shuts down.

    I think this may be (??) related to the fact that I am using a modeless user form that is constantly viewed by the user. The contents of the user form change every time a cell is changed. Since I have started using it, I have had a problem.

    Any suggestions?
    Thanks in advance,
    Patrick

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Any ideas?
    Thanks in advance,
    Patrick

  5. #5
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    loading funcres....that's the Analysis Toolpak addin loading--perhaps your code makes this occur? Not sure...

    You may want to post the code in your file right here and see if anyway can *troubleshoot* it for you.
    ~Anne Troy

  6. #6
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Okay - I got the loading funcres.xla cleared up. However, I am still having the zoom problem. When I hit print preview, the button is greyed out.

    Thanks in advance,
    Patrick

  7. #7
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I really need some help on this! I can not figure this out. On all other Excel files, Zoom is available.
    Thanks in advance,
    Patrick

  8. #8
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I'm willing to take a look at the file.

    Dreamboat@TheWordExpert.com
    ~Anne Troy

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com