| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set focus to cell?
After applying a 'column hide' I wish to set focus to a particular cell to
stop the columns being 'highlighted' after the user switches those columns back on... Yes I cannot find the .setFocus property in the vba intellisense..does not seem to exist..any ideas on how to simply set focus to cell after doing this: Range("C:M,R:R").EntireColumn.Hidden = True Selection.EntireColumn.Hidden = True btnSH.Caption = "Show Columns" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set focus to cell?
Range("C14").Select
HTH. Best wishes Harald skrev i melding ... After applying a 'column hide' I wish to set focus to a particular cell to stop the columns being 'highlighted' after the user switches those columns back on... Yes I cannot find the .setFocus property in the vba intellisense..does not seem to exist..any ideas on how to simply set focus to cell after doing this: Range("C:M,R:R").EntireColumn.Hidden = True Selection.EntireColumn.Hidden = True btnSH.Caption = "Show Columns" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable cell focus | Excel Discussion (Misc queries) | |||
| Active Cell/Focus | Excel Discussion (Misc queries) | |||
| Lost Focus - Applying to cell | Excel Programming | |||
| Cell Lost Focus | Excel Programming | |||
| Highlight Cell on Focus | Excel Programming | |||
Linear Mode
