An earlier thread put me on to creating a menu of worksheets that can be
selected for printing by adding a temporary dialog sheet (using
ActiveWorkbook.DialogSheets.Add - the full link is at
http://www.j-walk.com/ss/excel/tips/tip48.htm).

However, this does not appear to be possible if the workbook is shared.
Does any one know if there is a method that can be used in a shared workbook?

Thanks