If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sub procedure
We have a workbook with multiple worksheets. I have written a procedure
which checks for data outside of a specified range on the worksheet. Is it possible to have this procedure run automatically whenever a user activates a new worksheet in the workbook? I realize that the procedure can be tied to a key combination, or command button, but that requires input from the user. For this application we need to automate the process. Thanks, Jim |
#2
|
|||
|
|||
sub procedure
From workbook press Alt+F11 to launch VBE (Visual Basic Editor). From the
left treeview search for the workbook name and click on + to expand it. Within that you should see the following VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) This Workbook Double click 'This WorkBook' and check out the drop downs for the below event Private Sub Workbook_SheetActivate(ByVal Sh As Object) 'call your procedure here End Sub If this post helps click Yes --------------- Jacob Skaria "Jim" wrote: We have a workbook with multiple worksheets. I have written a procedure which checks for data outside of a specified range on the worksheet. Is it possible to have this procedure run automatically whenever a user activates a new worksheet in the workbook? I realize that the procedure can be tied to a key combination, or command button, but that requires input from the user. For this application we need to automate the process. Thanks, Jim |
#3
|
|||
|
|||
sub procedure
Thank you for your reply, however this event is not shown in the drop down
box. The events begin with AcceptLabelsInFormulas. Is it possible that I may be looking in the incorrect drop down box? Jim "Jacob Skaria" wrote: From workbook press Alt+F11 to launch VBE (Visual Basic Editor). From the left treeview search for the workbook name and click on + to expand it. Within that you should see the following VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) This Workbook Double click 'This WorkBook' and check out the drop downs for the below event Private Sub Workbook_SheetActivate(ByVal Sh As Object) 'call your procedure here End Sub If this post helps click Yes --------------- Jacob Skaria "Jim" wrote: We have a workbook with multiple worksheets. I have written a procedure which checks for data outside of a specified range on the worksheet. Is it possible to have this procedure run automatically whenever a user activates a new worksheet in the workbook? I realize that the procedure can be tied to a key combination, or command button, but that requires input from the user. For this application we need to automate the process. Thanks, Jim |
Thread Tools | |
Display Modes | |
|
|