p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)
-   -   Print preview "unhides" previously hidden objects (http://p2p.wrox.com/showthread.php?t=25398)

amerk20 February 10th, 2005 05:06 PM

Print preview "unhides" previously hidden objects
 
I've got an Excel 2003 form that has several ActiveX combo boxes. I have code that hides and unhides them based on actions taken by the user.

My problem is that, no matter what, whenever the user does a print preview, the previously hidden combo boxes become unhidden. To add to the problem, they are no longer placed where they should be. Instead, they all appear at the bottom of my form, stacked one on top of the other.

Any ideas as to what causes Print preview to unhide these? Any ideas on how to fix it??

Your help is much appreciated.

Rick

amjad_mahmood February 22nd, 2005 03:47 AM

I think you would have to do the following:
select each object individually, go to properties, look for the property "Print Object", disable it, I presume you have left all these objects with Print-Enabled, may be...




All times are GMT -4. The time now is 06:41 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.