only allow the workbook to close if the figure in A1 is between 500 and 600: : Workbook Event « Excel « VBA / Excel / Access / Word

VBA / Excel / Access / Word

1.	Access
2.	Application
3.	Data Type
4.	Data Type Functions
5.	Date Functions
6.	Excel
7.	File Path
8.	Forms
9.	Language Basics
10.	Math Functions
11.	Outlook
12.	PowerPoint
13.	String Functions
14.	Windows API
15.	Word
16.	XML

Java Source Code / Java Documentation

Java Open Source

Jar File Download

Photoshop Tutorials

Flash Tutorials

3ds-Max Tutorials

Illustrator Tutorials

C# / CSharp Tutorial

C# / CSharp Open Source

ASP.NET Tutorial

JavaScript DHTML

JavaScript Tutorial

JavaScript Reference

HTML CSS Reference

Python Tutorial

Python Open Source

SQL Server / T-SQL

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

VB.Net Tutorial

Flash / Flex / ActionScript

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

VBA / Excel / Access / Word » Excel » Workbook Event

only allow the workbook to close if the figure in A1 is between 500 and 600:


 

     Private Sub Workbook_BeforeClose(Cancel As Boolean)

           Dim dProfit As Double



           dProfit = ThisWorkbook.Worksheets(1).Range("A1").Value

           If dProfit < 500 Or dProfit > 600 Then

           MsgBox "Profit must be in the range 500 to 600"

           Cancel = True

           End If

     End Sub

Related examples in the same category

1.	If you want to prevent users from printing only particular sheets in your workbook, use this similar code instead:
2.	Preventing Users from Inserting More Worksheets
3.	If you want Excel to stop prompting you to save changes you didn't make
4.	Before Save event
5.	To link that tab's command bar to a right-click in any cell, enter the following code in the private module of ThisWorkbook:
6.	Pass value between events
7.	Workbook activation events
8.	minimizes the workbook's window:
9.	Workbook_BeforePrint
10.	use the BeforePrint event to add information to a header or footer before the sheet is printed
11.	BeforeClose event is used to delete a custom menu
12.	create your own Save dialog in the event:
13.	Set application key in Workbook Open event and BeforeCloseEvent
14.	Workbook open event
15.	Workbook Events Open: enable custom toolbar
16.	procedure is executed when the workbook is closed
17.	Workbook_SheetSelectionChange
18.	The BeforeClose event for a workbook
19.	The BeforeSave event for a workbook
20.	Activate and deactivate events in a workbook
21.	Cancel Close action based on the A1 value
22.	If you want to make sure that all changes are saved when the workbook closes
23.	to discard any changes to the workbook

www.java2java.com | Contact Us

Copyright 2009 - 12 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.