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" <(E-Mail Removed)> wrote in message
news:eJ$(E-Mail Removed)...
> 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
>

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

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" <(E-Mail Removed)> schrieb im Newsbeitrag
news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:eJ$(E-Mail Removed)...
>> 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
>>
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> schrieb im Newsbeitrag
> news:%(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:eJ$(E-Mail Removed)...
>>> 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
>>>
>>
>>
>
>