Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deselect (Unselect) Cells | Excel Discussion (Misc queries) | |||
Unselect Cells | Excel Programming | |||
How to unselect? | Excel Programming | |||
ActiveChart.Deselect won't Deselect | Charts and Charting in Excel | |||
Unselect a Cell?????? | Excel Programming |