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

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

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

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