Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Everyone,
I have installed a print command to print a page. I also added a msgbox to remind the person to turn on the printer. See below: Sub PrintFP() ' ' Print Flight Plan Info Macro ' Macro recorded 8/21/2004 by Michael Vaughan ' MsgBox "Be Sure Your Printer Is On!", vbInformation + vbOKCancel, "Printer Alert" Sheets("Print").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Sheets("Flight Plan").Select Range("B4").Select Well, the msgbox comes up ok.. but when I click on "Cancel" to NOT print.. it prints anyway??? What do I need to do to activate the cancel portion of the OKCancel?? Thanks.. mv |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work | Setting up and Configuration of Excel | |||
changing vbOKCancel button title | Excel Discussion (Misc queries) | |||
Exiting Sub when Selecting Cancel on vbOKCancel | Excel Discussion (Misc queries) | |||
Can't get Cancel to work in message box | Excel Discussion (Misc queries) | |||
cancel input | Excel Discussion (Misc queries) |