Unselect a Cell??????
 

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

--
Message posted from http://www.ExcelForum.com

Unselect a Cell??????
 

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 " wrote in message ...
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 any
other???????


---
Message posted from http://www.ExcelForum.com/

Unselect a Cell??????
 

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

--
Message posted from http://www.ExcelForum.com

Unselect a Cell??????
 

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 " wrote
in message ...
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 any
other???????


---
Message posted from http://www.ExcelForum.com/



.