Unselect a Cell??????

A

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??????
 
F

Frank Kabel

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

David McRitchie

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

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
 
G

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Andoni >" <<[email protected]> wrote
Click to expand...
in message news:[email protected]...
 
Top