Set Interactivity of Excel

[aboes81]

I am making an addin for excel, using .net, that will show a user form and allow them to select a range of cells. I would like to make it so the user cannot select menu items or close excel while my window is open. Is there a way to do this?

The behavior I'm looking for is similare to using the excel "Insert Function" form.

 

[Mike_R]

Hi aboes81,

To start off with, I would have a look at the article "How to Code a .NET RefEdit Control" by Gabhan Berry.(http://blogs.msdn.com/gabhan_berry/archive/2008/06/12/net-refedit-control.aspx) As you will see from reading the article, this is a pretty complex topic.

Disabling all the menu items while the user is using your form is a whole separate chapter unto itself, and would differ greatly depending on whether your add-in is running in Excel 2003 and below, in which case you would be disabling command bar controls, or Excel 2007, in which case you would be disabling Ribbon controls.

Mike