| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set focus
When opening any sheet in a workbook, I'd like to have a
the focus on a specific cell (say C,4). Any suggestions on what to use in the Sheet_Activate function? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
set focus
Private Sub Worksheet_Activate()
Cells(4, 3).Select End Sub HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- When opening any sheet in a workbook, I'd like to have a the focus on a specific cell (say C,4). Any suggestions on what to use in the Sheet_Activate function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a pop up window to focus? | Excel Discussion (Misc queries) | |||
| focus | Excel Discussion (Misc queries) | |||
| set focus | Excel Discussion (Misc queries) | |||
| Focus | Excel Worksheet Functions | |||
| Trouble with Focus | Excel Programming | |||
Linear Mode
