Disable Range Selection Change

[Chip Pearson]

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]

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

 

[Dr. Patrick Havel]

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]

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)