Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |