[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

    Search the Q&A Archives

I am new at all of this but I have a question regarding...

<< Back to: comp.apps.spreadsheets FAQ

Question by Kevin C. Black
Submitted on 10/29/2003
Related FAQ: comp.apps.spreadsheets FAQ
Rating: Rate this question: Vote
I am new at all of this but I have a question regarding Printing or PrintPreviewing requested by VBA code within a userform.  I can't seem to be able to view the PrintPreview screen after my VBA code has requested a preview.  Instead my userform stays on screen.  Is there a way to see the PrintPreview?  I tried hiding my userform, call up the PrintPreview and then showing the userform after the PrintPreview screen was closed by the user.  This seem to work but then I realized I must not quite understand the true actions of the .Hide and .Show methods because instead of the VBA code returning to the next line of code in my userform, after when the preview was requested, a whole new copy of the userform was loaded.  How do I either permit viewing the PrintPreview screens without hiding my userform OR how do I reshow my userform and return to the next line of code without nesting multiple copies of it?

Thanks for your answers
attention: K.C. Black

Answer by NonVBA
Submitted on 4/29/2005
Rating: Not yet rated Rate this answer: Vote
Rauchen = Marlboro


Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.


FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.


<< Back to: comp.apps.spreadsheets FAQ

[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

© 2008 FAQS.ORG. All rights reserved.