I have basically a C# application using Excel as a calculation engine. The
user is asked to identify where are the input and output data in an excel
sheet by selecting cells, rows and columns. So there are some "Pick a row",
"Pick a column", "Pick a unique cell" buttons that are managing the following
selection process:
1) show excel sheet to the user
2) wait for a selectionChange event
3) process the selection and hide excel immediately

Problem, the user is always able to select rows when I want a unique cell,
col when I need a row, etc. I can workaround that, but it becomes tricky.

So, is there a way to restrict the kind of item the user can pick to: one
cell, several cells, one row, seveal rows, one col, 2 cols, etc?
Thanks
--
STM