![]() |
How to control the user can or cannot select? Selection filter?
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 |
All times are GMT +1. The time now is 05:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com