Weirdness w/Zoom

[poleary2000]

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?

 

[Anne Troy]

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.

 

[poleary2000]

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?

 

[poleary2000]

Any ideas?

 

[Anne Troy]

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.

 

[poleary2000]

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.

 

[poleary2000]

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

 

[Anne Troy]

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

Dreamboat@TheWordExpert.com