Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searcing for an Excel event.
Hi
I am working on a ADD-IN for excel.I have requirement as follows. 1) I have created a Excel command bar and created some command butttons on it. 2) Button Start is a default command button which gets loaded with other buttons and shown to the user (Visble=true) and other buttons are hidden (visible=false). 3) The other buttons gets visible on some condtion i.e if a sheet named mySettings gets loaded to the workbook then they will appear to the workbook otherwise they will disapper (hideen). 4) I am searcing a event that will fire and search for the perticaulr sheet in workbook and gets activate and deactivate the command buttons on the command bar. If i am missing something then plz let me know so that i can make it more presise. Thanks __Das |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searcing for an Excel event.
Here's an example
Public WithEvents App As Application Private Sub App_SheetActivate(ByVal Sh As Object) With Application.CommandBars("Worksheet Menu Bar").Controls("MyMenu") .Controls("myButton").Visible = Sh.Name = "mySheet" End With End Sub Private Sub Workbook_Open() Set App = Application End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dwipayan Das" wrote in message ... Hi I am working on a ADD-IN for excel.I have requirement as follows. 1) I have created a Excel command bar and created some command butttons on it. 2) Button Start is a default command button which gets loaded with other buttons and shown to the user (Visble=true) and other buttons are hidden (visible=false). 3) The other buttons gets visible on some condtion i.e if a sheet named mySettings gets loaded to the workbook then they will appear to the workbook otherwise they will disapper (hideen). 4) I am searcing a event that will fire and search for the perticaulr sheet in workbook and gets activate and deactivate the command buttons on the command bar. If i am missing something then plz let me know so that i can make it more presise. Thanks __Das |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searcing foran Excel event fired. | Excel Worksheet Functions | |||
apply cell change event to single column - WorksheetChange Event | Excel Programming | |||
ad button for different rows after searcing in database | Excel Programming | |||
Searcing throught using part of string | Excel Programming | |||
repost: searcing multi excel files... | Excel Programming |