ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to control the user can or cannot select? Selection filter? (https://www.excelbanter.com/excel-programming/344458-how-control-user-can-cannot-select-selection-filter.html)

stm

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