Joanne,

Auto running a macro is achieved by using the Workbook_Open macro so you
could use:-

Private Sub Workbook_Open()
Worksheets.Add
End Sub

There's no point in adding any columns because the sheet already has as many
as is allowed.

With regard to the last bit I think you need to clarify what you mean
because numbering all column A would take a fair while and you would only end
up with duplicate row numbers.

Mike

"Joanne M." wrote:

What I need it this,

As soon as a user opens a specific file, the macro ( in vba), creates
another worksheet, inserts 3 columns and makes the first column auto
numbered. I am sure this isn't hard. But I am a "newbie" to this.

Can anyone help me?

Joanne