Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need help with code. With the code below, I want to be asked if I
want to delete the hours whether or not I print, but if I click "No" to the print question, I'm not asked if I want to delete the hours. Will someone please tell me what I need to add to my code? Msg = "Do you want to print?" Response = MsgBox(Msg, vbYesNo + vbQuestion) If Response = vbYes Then ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Msg1 = "Do you want to delete the hours?" Response1 = MsgBox(Msg1, vbYesNo + vbQuestion) If Response1 = vbYes Then Range("F3:H58").Select Selection.ClearContents Range("F45").Select Else Exit Sub End If End If End Sub Thanks! JD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic delete row in Excel 2003 | Excel Discussion (Misc queries) | |||
Cannot delete defalut Chartin excel 2003 | Charts and Charting in Excel | |||
Delete empty rows from print in Excel | Excel Worksheet Functions | |||
how can I delete the print box that pops up to show document print | Excel Discussion (Misc queries) | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) |