View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Sheet Jack Sheet is offline
external usenet poster
 
Posts: 47
Default Show print dialog box

Hi all
I have a line of code:
If .Range("AbsValue").Value 0 Then .PrintOut

This sends the identified range to the default printer.
I would prefer if it opened the standard dialog box that prompts you to
select the printer first, and vary as desired the printer properties.
In other words, I want it to behave as though you clicked on File/Print from
the menu bar, instead of clicking on the printer icon from the standard
toolbar.

How to achieve this, please?
Still using Office 97 :-(

Many thanks.

--
Return email address is not as DEEP as it appears