Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Selection in Excel
Whenever I open a Worksheet/Workbook I want a particular cell, say A1, should
be selected irrespective of which cell was selected when I last saved the Worksheet/Workbook. Any suggestions pls.? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Selection in Excel
Private Sub Workbook_Activate()
ActiveSheet.Range("A1").Select End Sub Private Sub Workbook_SheetActivate(ByVal Sh As Object) Sh.Range("A1").Select End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "RM Batcha" wrote in message ... Whenever I open a Worksheet/Workbook I want a particular cell, say A1, should be selected irrespective of which cell was selected when I last saved the Worksheet/Workbook. Any suggestions pls.? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, Windows XP, Stuck in Cell Selection Mode | Excel Discussion (Misc queries) | |||
First row in Selection range (first index of a cell) EXCEL VBA | Excel Worksheet Functions | |||
Set a cell to have a pop-up calendar for date selection in Excel? | Excel Worksheet Functions | |||
Excel-can't turn off multiple cell selection or add text/numbers | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |