print preview without ability to edit

M

macroapa

Hi, I have a whole load of VBA code and userforms that are presented
to the user to create letters.

Now at the end, the letter goes out the door automatically without the
user ever seeing the letter or being able to amend what has been
produced.

What I would like to do is an the ability to 'preview' the produced
letter, BUT, not allow the user to be able to edit. So is is possible
within the runtime (and before the final userform is presented) to
load the print preview of the letter and when print preview is closed
the next and final userform is presented?

Thanks for any pointers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with SET & REF function 0
Is it possible to edit colours already saved as part of a custom theme? 0
Project Professional 2016 - Headers and footers not showing up in print preview & printed document 2
Gridlines display in Print preview but do not print 4
Setting Print Preview Default Size 0
Print Preview Doesn't Trigger BeforePrint Event 1
How can I print rows that go outside of the page without shrinking the text? 0
Print Preview Exit Problem 0

Top