Hi,

I'm new at using vsto for excel. I created a vsto for excel, added some sheets, with data,... I also added a few named ranges, . My question is the following: Is it possible to catch the event when the users deletes a 'Named Range'.

This to prevent that the named ranges that I created will be deleted, and that the user is allowed to delete his own named ranges, but not my named ranges.

TIA,

Isabel

Isabel,

Take a look at the Sample that illustrates how to protect various controls on your Excel worksheet. http://msdn2.microsoft.com/en-us/library/ms268876.aspx

Thanks.