Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to open Print window
Hello,
Just a quick one. Does anyone know what the VB code is to open the Print box (ie when you click FilePrint) thanks, Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to open Print window
Application.Dialogs(xlDialogPrint).Show
-- HTH RP (remove nothere from the email address if mailing direct) "OscarC" wrote in message ... Hello, Just a quick one. Does anyone know what the VB code is to open the Print box (ie when you click FilePrint) thanks, Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to open Print window
Application.Dialogs(xlDialogPrint).Show
Hope this helps "OscarC" wrote: Hello, Just a quick one. Does anyone know what the VB code is to open the Print box (ie when you click FilePrint) thanks, Michael |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to open Print window
On Mon, 6 Dec 2004 22:35:13 -0000, "Bob Phillips"
wrote: Application.Dialogs(xlDialogPrint).Show Thanks! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to open Print window
"OscarC" wrote in message ... Hello, Just a quick one. Does anyone know what the VB code is to open the Print box (ie when you click FilePrint) thanks, Michael Hi Michael Sub prinit () ActiveWindow.SelectedSheets.PrintPreview End Sub n10 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How I can I open a small window within window | Excel Discussion (Misc queries) | |||
VBA line of code executes in Immediate Window but not in Code Window | Excel Discussion (Misc queries) | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) |