Unselect a Cell??????

[Andoni]

Thanks in advance!

Usually when I do work with vba, one of the cells is always selected
say eg range("A1")

but how can I unselect the selected cell without selecting an
other??????

 

[Frank Kabel]

Hi
at least ONE cell always has to be selected. Why is this important for
you?

 

[David McRitchie]

Why do want to do this. I think it may actually be possible,
but I don't know how.

 

[Andoni]

Hi!

I saw a few excel programs.
when their vba code is running
the "say name cell" above Range("A1") is blank

I do not know the english name of this place anyway is on the left o
the formula bar "Fx"


I am trying to use those DLL:

Declare Function GetAsyncKeyState Lib "user32" (ByVal nVirtKey A
Long) As Integer
Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)


and when i press down the activecell goes down, and I do not want t
use every time scrollup... every single movemet

is more complicated than this, but i saw, this once, and i can'
remenber what was the command


but i do know there is one!

Many Thanks

 

[Garry]

Try this line of code. This will work if all cells are
locked.
ActiveSheet.EnableSelection = xlUnlockedCells

-----Original Message-----
Why do want to do this. I think it may actually be possible,
but I don't know how.


"Andoni >" <<[email protected]> wrote

in message news:[email protected]...