Searching for an Event to fire if a perticaular sheet get loads .

D

Dwipayan Das

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searcing for an Excel event. 1
Searcing foran Excel event fired. 1
What are the events get fired when Excel gets loaded with all shee 2
Can't get Sheet_Change event to fire - please help 4
Outlook events cease to fire during a session 0
Help.. Add an event to a sheet module 1
How do I get Pivot filter change event to fire? 4
How to stop Stephen Bullen's CFormChanger from minimizing as an MDItitle bar? 7

Top