PC Review


Reply
Thread Tools Rate Thread

automatic close of pages

 
 
N+
Guest
Posts: n/a
 
      11th Jun 2008
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 With Quote
 
 
 
 
NateBuckley
Guest
Posts: n/a
 
      11th Jun 2008
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic close of outlook Lener Microsoft Outlook Discussion 10 1st Jul 2009 02:28 PM
How to close WEB pages ? javiernews via AccessMonster.com Microsoft Access VBA Modules 9 8th Dec 2006 05:53 PM
Automatic Close window Geoplay Spyware Discussion 10 2nd Dec 2006 04:49 AM
IE window automatic close =?Utf-8?B?SXZhbg==?= Windows XP Help 0 5th Sep 2004 10:45 AM
IE Automatic Close SK Chaw Windows XP Internet Explorer 1 17th Jun 2004 11:35 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:59 PM.