How to neutralize Active Cell?

T

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.
 
J

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
 
B

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)
 
J

Jack

Thanks. That will work. :)
Bob Phillips said:
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)
Click to expand...
 
Top