Auto run of macros immediately after opening the files
Hey gane
to do that, open your excel sheet, press Alt + F11,
then you should see on the left side your sheets and
the whole workbook, if not press ctrl+r....double click
on the workbook and choose instead of (General) --
workbook. this should lead to this:
---------------------------------------------------
Private Sub Workbook_Open()
End Sub
---------------------------------------------------
Now you can paste following between those lines:
---------------------------------------------------
ActiveSheet.Range("A1").Select
---------------------------------------------------
Where you can change the Range to what you want.
Close the workbook and reopen it.
hth
Carlo
On Oct 31, 4:29 pm, gane wrote:
hai
i saved the worksheet by placing the cursor at some cell (say a200) and i
had closed the file. If i open the file, the cursor/worksheet should start
from first cell (say a1) or any cell which i assign
Pls help me to solve my problem
|