Unselect? Deselect?
 

I have a locked spreadsheet and the last thing people do it type data into a
textbox. They are unable to select anything else so when the macro runs, this
box remaining selected causes problems with the macro.

If I have a textbox active, how do I go about unselecting it and having
nothing selected on the worksheet?

I have tried unsuccesfully various focus commands and even "unselect." any
help?

Unselect? Deselect?
 

There is always something selected in a worksheet. An active sheet must
always have an active cell. Even when you select the textbox the active cell
remains. The only way to unselect a range is to select a different range.
What part of your code (post your code) is having a problem with the textbox
being selected.
--
HTH...

Jim Thomlinson


"jayklmno" wrote:

I have a locked spreadsheet and the last thing people do it type data into a
textbox. They are unable to select anything else so when the macro runs, this
box remaining selected causes problems with the macro.

If I have a textbox active, how do I go about unselecting it and having
nothing selected on the worksheet?

I have tried unsuccesfully various focus commands and even "unselect." any
help?