|
|||||||||
|
|||||||||
|
||||||||||||||||||||||||||||
» 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. | ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
 | ||||||||||||||||
Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
Positioning: The Battle for Your Mind
The 22 Immutable Laws of Branding
Understanding Financial Statements
The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks) | ||||||||||||||||
| ||||||||||||||||
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 |
|