Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unselect cells | Excel Discussion (Misc queries) | |||
How do I unselect a cell in Excel? | Excel Discussion (Misc queries) | |||
How do I unselect a cell in a macro | Excel Discussion (Misc queries) | |||
Unselect Option Box | Excel Discussion (Misc queries) | |||
Can't unselect a cell - What's wrong??????????? | Excel Discussion (Misc queries) |