What would be the equivalent in VBA code to the Right
click on the worksheet tab where you can then Copy the
sheet or sheets to another workbook (which in this case
would be a new one).

Can anyone help?

Many thanks
Jacqui

Hi Jacqui,

This macro will copy the first worksheet in the workbook where it runs
into a new workbook:

Sub CopySheet()
ThisWorkbook.Worksheets(1).Copy
End Sub

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"jacqui" wrote in message
...

What would be the equivalent in VBA code to the Right
click on the worksheet tab where you can then Copy the
sheet or sheets to another workbook (which in this case
would be a new one).

Can anyone help?

Many thanks
Jacqui

One way:

ActiveWindow.SelectedSheets.Copy

In article ,
"jacqui" wrote:

What would be the equivalent in VBA code to the Right
click on the worksheet tab where you can then Copy the
sheet or sheets to another workbook (which in this case
would be a new one).

Can anyone help?

Many thanks
Jacqui