| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic close of pages
hi all !!!
in presence of a "false" in my cell a1 i want my worksheet to save and close.. can u help me ?? ty , paolo |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
automatic close of pages
Copy this into your sheet of choice.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Cells(1, 1).Value = False Or Cells(1, 1).Value = "FALSE" Then ThisWorkbook.Save Application.Quit End If End Sub Hope this helps! "N+" wrote: hi all !!! in presence of a "false" in my cell a1 i want my worksheet to save and close.. can u help me ?? ty , paolo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of pages in worksheet doesn't match Print Preview pages | Excel Discussion (Misc queries) | |||
| Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages.. | Setting up and Configuration of Excel | |||
| turn off/on automatic calc upon open/close workbook? | Excel Programming | |||
| How do I delete pages from an Excell template of mutiple pages | Excel Discussion (Misc queries) | |||
| Copy/close web pages | Excel Programming | |||
Linear Mode
