Easy one: Focus off individual cell?

  • Thread starter Thread starter jasonsweeney
  • Start date Start date
J

jasonsweeney

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top