Hiding and displaying selected rows programatically
 

Greetings:

We are using Excel to write lists of manual test cases for a record keeping
application. As the code goes through successive iterations, adding new
features and refining existing ones, the test case workbooks evolve as well.
In each iteration, a workbook will have obsolete test, tests under
development and tests for functions that are not yet available, as well as
tests that are valid for the current iteration. The test engineer needs to
have access to all of theses tests, but the tester should only see the valid
tests.

I want to make a tool bar with buttons to selectively display test case
rows: display all rows, display valid tests, etc. I know this can be done
using VBA programming, but my management wants all new code to be written in
C#. So my questions are these:

1. Is it possible to code this in C#, possibly using VSTO?
2. Assuming it is possible, what is the advantge to going this route, versus
sticking with VBA?

Thanks in advance for your help.


--
Cleverly disguised as a fully qualified Software Engineer