Hi Jim,

It works!! My question now is why? How does it know that sheet1 is the one
in my Add-in and not the one in the current workbook for instance?

Thank you.

Eric



"Jim Thomlinson" wrote in message
...
Your OnAction must be a text string and not an executable action...
something
like this...

With cbMenu.Controls.Add(msoControlButton, 1, , , True)
.Caption = "Test template"
.OnAction = "Module1.CopySheet1"
End With

'In module 1 place this code...

public sub CopySheet1()
sheet1.copy
end sub
--
HTH...

Jim Thomlinson


"Eric" wrote:

Still does not work, and no, the sheet is visible.

How does the command know that the sheet is coming from the Add-in?

Here's what I have so far:

With cbMenu.Controls.Add(msoControlButton, 1, , , True)
.Caption = "Test template"
.OnAction = Sheets("Test1").Copy
End With

Thank you.


Eric

"Jim Thomlinson" wrote in
message
...
Have you made the sheet in the addin hidden (which is not necessary
since
the
sheets in an addin are not visible by virtue of being an addin? That
being
the case...

Sheet1.Visible = xlSheetVisible
Sheet1.Copy

--
HTH...

Jim Thomlinson


"Eric" wrote:

Sorry but this does not work either. The sheet I want to copy is in
the
Add-in but is not apparent..

Thank you.

Eric



"Jim Thomlinson" wrote in
message
...
Sheet1.Copy
or
Sheets("Sheet1").Copy
--
HTH...

Jim Thomlinson


"Eric" wrote:

Tom,

The command does not work (doesn't do anything, not even an error)
but
maybe
I wasn't clear enough.

My Add-in had 2 sheets called test1 and test2. The Add-in is not
opened
but
just "loaded" through Tools / Add-ins ....
Once loaded the Add-in creates a menu. I'd like to be able to
create
automatically a new workbook with a new sheet based on (copied
from)
test1
or test2 from the loaded Add-in.

Thank you again.

Eric

"Tom Ogilvy" wrote in
message
...
thisworkbook.Worksheets(1).Range("A1").Value

--
Regards,
Tom Ogilvy



"Eric" wrote:

Hello,

I am learning VBA and I just created several templates/forms
(sheets)
that I
saved into an Add-in.
The Add-in creates automatically a menu item and I would like
to be
able
to
call the templates (sheets) saved in the Add-in from this menu.

How can I do that? What would be the command to execute?

Thank you.

Eric


.