Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i start Excel in a particular cell?
Is there a way that when i open Excel (whether in general or a particular
file) that it will begin in a particular cell; regardless of where the user was when the file was closed?? Thanks in advance |
#2
|
|||
|
|||
Private Sub Workbook_Open()
Worksheets("Sheet1").Activate 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 RP (remove nothere from the email address if mailing direct) "lennyx2" wrote in message ... Is there a way that when i open Excel (whether in general or a particular file) that it will begin in a particular cell; regardless of where the user was when the file was closed?? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
Mouse continues to select after clicking on a cell in excel. | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |