Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 691
Default 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/



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default 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/



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unselect cells tgi Excel Discussion (Misc queries) 1 October 1st 09 03:21 AM
How do I unselect a cell in Excel? doccojohn Excel Discussion (Misc queries) 2 February 17th 09 01:38 PM
How do I unselect a cell in a macro cgnotrom Excel Discussion (Misc queries) 2 June 14th 08 01:32 AM
Unselect Option Box Jon Excel Discussion (Misc queries) 1 May 18th 05 01:02 AM
Can't unselect a cell - What's wrong??????????? Andre Excel Discussion (Misc queries) 1 May 10th 05 12:23 AM


All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"