anyone? would be useful if I could get this to work as I have a nic
userform where users can select which printer they want with an optio
button, and it then prints 5 sheets from the spreadsheet to th
selected printer

--
neowo
-----------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...nfo&userid=594
View this thread: http://www.excelforum.com/showthread.php?threadid=27202

xlDialogPrinterSetup=9, so ...



Option Explicit
Sub testme()
Dim okToPrint As Boolean
okToPrint = Application.Dialogs(xlDialogPrinterSetup).Show
If okToPrint Then
'print it
Else
MsgBox "cancelled!"
End If
End Sub


neowok wrote:

anyone? would be useful if I could get this to work as I have a nice
userform where users can select which printer they want with an option
button, and it then prints 5 sheets from the spreadsheet to the
selected printer.

--
neowok
------------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940
View this thread: http://www.excelforum.com/showthread...hreadid=272024

--

Dave Peterson