|
|||||||||
|
|||||||||
|
||||||||||||||||||||||||||||
» Worksheet events using VBA in Microsoft Excel
 | ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
|
Events for the worksheet object occurs when a worksheet is activated or the user changes the content of a cell. Events in worksheets are activated by default, but can be deactivated by a macro. To display the event procedures for a worksheet you use the Visual Basic editor. Select the desired project in the Project-window and activate the worksheet object you want by doubleclicking it. Any event procedures in the worksheet will now be displayed in the Code-window on the right side of the screen. You can create a new event procedure by selecting Worksheet in the Object dropdown, and then select an event in the Procedure dropdown. Macros can be attached to the following events in a worksheet:
the procedure must be written in the worksheets own module sheet, e.g. Sheet1:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Excel.Range, _
Cancel As Boolean)
Cancel = True
MsgBox "Shortcut menus are disabled in this worksheet!"
End Sub
This example eventmacro will prevent the user from selecting cells in a specific range in a worksheet, the procedure must be written in the worksheets own module sheet, e.g. Sheet1:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Not Application.Intersect(Target, Range("A1:A100")) Is Nothing Then
Cells(ActiveCell.Row, 2).Select
MsgBox "You can't select cells in A1:A100!"
End If
End Sub
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
|
READER COMMENTS (view all comments) |
||||||||||||||||
|
No comments have been submitted. | ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
 | ||||||||||||||||
The 22 Immutable Laws of Branding
Investing for Dummies, Third Edition
VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
Harry Potter and the Order of the Phoenix (Book 5)
Word 2002: The Complete Reference | ||||||||||||||||
| ||||||||||||||||
RELATED MICROSOFT EXCEL TIPS
 |
• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books
|
Terms
and Conditions of use |
|
|
Copyright © 2003 ExcelTip.com |
|