set to display cursur on cell A1

  • Thread starter Thread starter Anoop
  • Start date Start date
A

Anoop

i want to display cursur on cell A1 in evry time when i open a workbook,
which was done some work by me
 
Set the security level to low/medium in (Tools|Macro|Security). From workbook
press Alt+F11 to launch VBE (Visual Basic Editor). From the left treeview
search for the workbook name and click on + to expand it. Within that you
should see the following

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
This Workbook

Double click 'This WorkBook' and paste the below code to the right code pane.

Private Sub Workbook_Open()
Range("A1").Activate
End Sub

If this post helps click Yes
 
Back
Top