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

Hi, use the macro recorder to created actions you require, then copy
and paste the macro in the workbook open event



this site

http://contextures.com/xlvba01.html

will show you where the modules are located


eventually it will be in a spot like this

Private Sub Workbook_Open()
'your code here
End Sub

On Jun 15, 9:59 am, Paul Morgan <paulandrewmor...@gmail.com> wrote:
> Hi, use the macro recorder to created actions you require, then copy
> and paste the macro in the workbook open event
>
> this site
>
> http://contextures.com/xlvba01.html
>
> will show you where the modules are located
>
> eventually it will be in a spot like this
>
> Private Sub Workbook_Open()
> 'your code here
> End Sub

Let me try this.

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
>
>