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