ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Easy one: Focus off individual cell? (https://www.excelbanter.com/excel-programming/294504-easy-one-focus-off-individual-cell.html)

jasonsweeney[_62_]

Easy one: Focus off individual cell?
 
What I need to do is this:

After a user clicks on a cell, a macro fires changing the value of th
cell. But the cell remains "selected." what I want to do is to no
have that cell selected. Currently, I just have the macro selec
another cell (via offset):

e.g.: Target.offset(0,1).select

I would rather just have no other cell selected, however....is thi
possible? Just to have no cells "selected"? For example, if I was VB
God I would love to have the code: Selection = Off

thanks in advance for hel

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


kkknie[_10_]

Easy one: Focus off individual cell?
 
I'm pretty sure something has to be selected. One option is have
column or row with almost no height/width and select a cell there.
Another is to add a very small drawing object (from the drawin
toolbar) and select it.



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



All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com