Use the Workbook_Open event. You go into the vbe and right click on the
thisworkbook entry in your project in the project explorer, selecting view
code. In the resulting module, select Workbook from the left dropdown at the
top and Open from the left one.

Private Sub Workbook_Open()

End Sub

Put your code in this procedure or call it from this procedure.

If you want to allow the user to make entries, lock all cells but the ones
where the entries will be made - those should be unlocked. Then protect the
sheet. for the sheet, set EnableSelection = xlUnlockedCells

But, this will allow the curor to be shown - you can't have it both ways.

--
Regards,
Tom Ogilvy

"Ben" wrote in message
...
Tom,

it works great! :)
Thanks.

But is it also possible to run it in a macro, and each time excel is
started
the macro automaticly runs?

Another question.....

I have a form in wich the user must fill data.
For instance in A1, A2, A3, F7
Is it possible that after input from A3 to jump to F7?

Ben
Tom Ogilvy schreef in berichtnieuws
...
Lock all cells (Format=Cells=Protection tab)

Protect the sheet (Tools=Protect=Worksheet)

change the EnableSelection Property of the worksheet to xlNoSelection.

this property will need to be set each time the workbook is opened.

--
Regards,
Tom Ogilvy


B. Wassen wrote in message
...
Is it possible to hide the cursor?