Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'd like a checkbox to be unchecked when the user goes to
a different worksheet in the same workbook. What function should I use? thanks! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You may use the following event-functions of the 'ThisWorkbook' module
Private Sub Workbook_SheetActivate(ByVal Sh As Object 'manage your checkbox as you wan 'Sh is the new active worksheet End Sub Private Sub Workbook_SheetDeactivate(ByVal Sh As Object 'manage your checkbox as you wan 'Sh is the new active worksheet End Su or the event-functions of the worksheet module Private Sub Worksheet_Activate( 'manage your checkbox as you wan End Su Private Sub Worksheet_Deactivate( 'manage your checkbox as you wan End Su |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |