| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Move curser to specific cell when closing
I'd like to have Sheet2 cell B3 the active cell when closing workbook. I know
the code goes in Workbook_BeforeClose(Cancel as Boolean). I just don't know how to word it? Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move curser to specific cell when closing
Hi Richard:
Private Sub Workbook_BeforeClose(Cancel As Boolean) Sheets("Sheet2").Activate Range("B3").Select End Sub By the way, this is a good practice. -- Gary''s Student "Richard" wrote: I'd like to have Sheet2 cell B3 the active cell when closing workbook. I know the code goes in Workbook_BeforeClose(Cancel as Boolean). I just don't know how to word it? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I move cursor in an active cell without using delete/backsp | Excel Discussion (Misc queries) | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| automatically move results from a calculation to a specific cell | Excel Worksheet Functions | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| I can't move from cell to cell with arrow or enter keys. Help! | Setting up and Configuration of Excel | |||
Linear Mode
