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


.