Re: Macro to view 'Print' dialog box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Jakey,

Try:

Application.Dialogs(xlDialogPrint).Show

---
Regards,
Norman



"JakeyC" <mrjsoftware@xxxxxxxxxxx> wrote in message
news:1129371537.892017.302650@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi -
>
> I need to use a macro to bring up the same dialog box that appears when
> you select 'Print...' from the File menu.
>
> I tried to record a macro to see the code, but it only gives code for
> 'Ok, go ahead and print with these options' rather than just displaying
> the dialog box, and awaiting user input.
>
> Any ideas?
>


.

Relevant Pages

  • Re: Insert cell anywhere
    ... Thanks for replying again, I pasted your suggestion into my macro, it worked ... Regards J. ... "Norman Jones" wrote: ... > Sub Tester04() ...
    (microsoft.public.excel.programming)
  • Re: Copy row if....
    ... > doesn't that carry an implicit negative connotation to it? ... Regards, ... Norman ... >>> I hv one further question regarding macro, is there a website on macro ...
    (microsoft.public.excel.programming)
  • Re: WORKBOOKS.OPEN (URL) - How to trap a connection-lost/ timeout
    ... > I need to retrieve the market data from a remote location, so there's no> business alternative for me. ... Either the exchange website or a Bloomberg/> Reuters machine on the network. ... I need a way for> my macro to exit if it does not receive a response from a remote computer for> a file request. ... >> Regards Ron de Bruin ...
    (microsoft.public.excel.programming)
  • Re: macro -find all occurences of a word-change color of cell of all
    ... Regards, ... Norman ... > I need a macro to find all occurences of the word "Count" in Column B, ...
    (microsoft.public.excel.programming)
  • Re: Annoyance: Documents opening in markup mode
    ... In regards to your macro question, you might find this webpage helpful. ... Kind Regards ... switch off markup mode, ...
    (microsoft.public.word.vba.general)