Excel menu programmed in .Net through PIA
 

Hello,

I am using the PIA interop utilities in order to develop
a solution within the .Net framework for an MS Excel as a
GUI.

Does anyone have an idea how I can add a menu item
(preferably a menu item as well as a right click floating
menu item) that will appear only when a specific sheet is
in focus. Ideally the menu item(s) will appear when the
focus is with a certain range of cells only. However, we
could easily live with the menu item(s) being visible
when the sheet is in focus.

So if the workbook contains sheet1, sheet2 and sheet3. I
would like the menu item to appear only when the user is
working within sheet1. Or better yet when the user
clicks on cell sheet1!A1, A2, B1 or B2.

Thanks,
Avi