There are a couple of questions in here so here goes;
From what I can see, 1) - The Addin application you apply your ribbon xml to will fire and capture the callback event for the button being clicked, from here it is simply a matter of checking the button name (One of the eventargs) and then applying the code to activate the sheet. This.Workbooks(0).Activate
2) - This is a bit more confusing as there are a few ways you can handle this, you can create a delegate watching the change event and note changes at the time of change and update the usercontrol code, this is probably the easiest but I am not at my pc to do a couple of sample tests for you.
Regards
Mike Walker MVP - Visual Developer VSTO - Please mark the best replies as Answers ! |