List Printers In Dialog Box On Web Workbook

Hi all,

I have a userform and code to print selected worksheets from a listbox, adapted from here I think, which works fine when run from a workbook saved on my (and other) PC, but the file is now on a website and when downloaded runs as one of those hybrid Excel-IE files and the button to show the list of printers now produces an error. I assume this is because it is not a 'normal' Excel workbook? Does anyone have any suggestions?

Private Sub cmdprinter_Click()


Application.Dialogs(xlDialogPrinterSetup).Show


End Sub

produces "Show method of Dialog class failed".

Thanks in anticipation.

Steve

Re: List Printers In Dialog Box On Web

Thanks Dave, I'll give that a try.