How to neutralize Active Cell?
 

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

How to neutralize Active Cell?
 

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.

--
Regards,
Tom Ogilvy

"Jack" <replyto@newsgroup wrote in message
...
Hello,
I need programmatically to 'clear' ActiveCell status.
How can I do that?

How to neutralize Active Cell?
 

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

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"Jack" <replyto@newsgroup wrote in message
...
Hello,
I need programmatically to 'clear' ActiveCell status.
How can I do that?

How to neutralize Active Cell?
 

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" <replyto@newsgroup wrote in message
...
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

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"Jack" <replyto@newsgroup wrote in message
...
Hello,
I need programmatically to 'clear' ActiveCell status.
How can I do that?

How to neutralize Active Cell?
 

Thanks. That will work. :)
"Bob Phillips" wrote in message
...
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" <replyto@newsgroup wrote in message
...
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

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

"Jack" <replyto@newsgroup wrote in message
...
Hello,
I need programmatically to 'clear' ActiveCell status.
How can I do that?