How to neutralize Active Cell?

[Jack]

Hello,
I need programmatically to 'clear' ActiveCell status.
How can I do that?

 

[Tom Ogilvy]

You mean so ActiveCell is Nothing. Don't believe you can do that. If you
are trying to not have a cell visibly selected, then move the selection off
the visible portion of the page or lock all cells, set the enable selection
property to noselection and protect the sheet.

 

[Jack]

Yes, thats what I need. The best will be to set ActiveCell to Nothing.
If that is impossible I need another solution.
The code I use to detect user's click on Excel cell is activated when the
user CHANGES the active cell.
In the initial situation, when user selects cell then activates my program,
then clicks on THE SAME cell my code will not receive any event from Excel.
How to move active cell to something else to force user to repeat his
action?
Thanks,
Jack

 

[Bob Phillips]

Jack,

I have had this problem, so what I did was to activate the adjacent cell in
the select/change event. Thereafter, another click in the original generates
a new select.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Jack]

Thanks. That will work.

Jack,

I have had this problem, so what I did was to activate the adjacent cell in
the select/change event. Thereafter, another click in the original generates
a new select.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)