Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following does close the active workbook, but it also needs to
totally exit all current sub as well as the call procedure this is part of? any ideas? Sub NotAllowed() Dim Msg As String, Title As String Dim Config As Integer, ans As Integer Msg = " This process may NOT be used on an " Msg = Msg & vbNewLine & vbNewLine Msg = Msg & " 'E-Mail Safe' File" Msg = Msg & vbNewLine & vbNewLine Msg = Msg & " Please click on OK" Msg = Msg & vbNewLine & vbNewLine Msg = Msg & " You will be exited from this procedure" Msg = Msg & vbNewLine & vbNewLine Config = vbOKOnly = vbExclamation ans = MsgBox(Msg, Config, Title) If ans = vbOK Then ActiveWorkbook.Close ' Somehow require an end or exit here |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
inserting a number from a particular cell based on if/thens | Excel Discussion (Misc queries) | |||
Macro to combine data based on IF,THENs? | Excel Programming | |||
Have "IF,Then" to get data from multiple columns--can I nest add'l IF,THENs? | Excel Worksheet Functions | |||
Bolding with formulas and "if/thens" | Excel Worksheet Functions |