Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Range Selection Change
Patrick,
I don't know C++ well enough to give you the C++ code (I dabble in it, but don't do commercial work with it other than a few special-purpose DLLs), but in VBA, you would use something like Dim WS As Worksheet Set WS = Worksheets("Sheet3") ' << CHANGE SHEET NAME AS REQUIRED WS.EnableSelection = xlNoSelection ' or possibly xlUnlockedCells Be sure to set EnableSelection back to xlNoRestrictions when appropriate. The translation to C++ should be pretty simple. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email on the web site) "Dr. Patrick Havel" wrote in message ... Hi *, in my C++ program I write programatically (by COM interface) OPC measured values into Excel cells. In order not to disturb the program write processing I need to disable userīs range selection change during the program access. How can I do that? Thanks, Patrick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Range Selection Change
Hi *,
in my C++ program I write programatically (by COM interface) OPC measured values into Excel cells. In order not to disturb the program write processing I need to disable userīs range selection change during the program access. How can I do that? Thanks, Patrick |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Range Selection Change
Hi Chip,
I tested both possibilities (xlNoSelection and xlUnlockedCells) but I donīt see any effect (I can select cells by mouse click as before). Regards, Patrick "Chip Pearson" schrieb im Newsbeitrag ... Patrick, I don't know C++ well enough to give you the C++ code (I dabble in it, but don't do commercial work with it other than a few special-purpose DLLs), but in VBA, you would use something like Dim WS As Worksheet Set WS = Worksheets("Sheet3") ' << CHANGE SHEET NAME AS REQUIRED WS.EnableSelection = xlNoSelection ' or possibly xlUnlockedCells Be sure to set EnableSelection back to xlNoRestrictions when appropriate. The translation to C++ should be pretty simple. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email on the web site) "Dr. Patrick Havel" wrote in message ... Hi *, in my C++ program I write programatically (by COM interface) OPC measured values into Excel cells. In order not to disturb the program write processing I need to disable userīs range selection change during the program access. How can I do that? Thanks, Patrick |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Range Selection Change
I forgot to add that you have to protect the worksheet in order for these
settings to take effect. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email on the web site) "Dr. Patrick Havel" wrote in message ... Hi Chip, I tested both possibilities (xlNoSelection and xlUnlockedCells) but I donīt see any effect (I can select cells by mouse click as before). Regards, Patrick "Chip Pearson" schrieb im Newsbeitrag ... Patrick, I don't know C++ well enough to give you the C++ code (I dabble in it, but don't do commercial work with it other than a few special-purpose DLLs), but in VBA, you would use something like Dim WS As Worksheet Set WS = Worksheets("Sheet3") ' << CHANGE SHEET NAME AS REQUIRED WS.EnableSelection = xlNoSelection ' or possibly xlUnlockedCells Be sure to set EnableSelection back to xlNoRestrictions when appropriate. The translation to C++ should be pretty simple. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email on the web site) "Dr. Patrick Havel" wrote in message ... Hi *, in my C++ program I write programatically (by COM interface) OPC measured values into Excel cells. In order not to disturb the program write processing I need to disable userīs range selection change during the program access. How can I do that? Thanks, Patrick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change Selection to specific Range | Excel Discussion (Misc queries) | |||
disable selection of pictures | Excel Programming | |||
disable range selection | Excel Programming | |||
Disable menu selection | Excel Discussion (Misc queries) | |||
Macro to change list box input range based on selection made in another cell | Excel Programming |