Weirdness w/Zoom

poleary2000 · Apr 3rd, 2002, 04:04 PM

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 · Apr 3rd, 2002, 05:29 PM

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 · Apr 3rd, 2002, 08:40 PM

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 · Apr 4th, 2002, 05:07 AM

Any ideas?

Anne Troy · Apr 4th, 2002, 06:45 AM

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 · Apr 4th, 2002, 02:39 PM

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 · Apr 4th, 2002, 03:40 PM

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

Anne Troy · Apr 4th, 2002, 05:17 PM

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

Dreamboat@TheWordExpert.com

Apr 3rd, 2002, 04:04 PM	#1
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	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

Apr 3rd, 2002, 05:29 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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

Apr 3rd, 2002, 08:40 PM	#3
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	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

Apr 4th, 2002, 05:07 AM	#4
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	Any ideas? __________________ Thanks in advance, Patrick

Apr 4th, 2002, 06:45 AM	#5
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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

Apr 4th, 2002, 02:39 PM	#6
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	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

Apr 4th, 2002, 03:40 PM	#7
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	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

Apr 4th, 2002, 05:17 PM	#8
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	I'm willing to take a look at the file. Dreamboat@TheWordExpert.com __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode