Excel VBA - Changing a template in an Add-in

[FrankE]

Some time ago, I created an Excel Add-in which included several macro
and two templates. I'd like to change one of the templates, but can'
remember how to access a template in an add-in.
When I open the add-in, the sheets are hidden and the code is availabl
using the VBA editor. The templates show in the Project explorer map.

How can I make the templates visible and change them?

Thanks
Fran

 

[Bob Phillips]

Frank,

Via the IsAddin property.

Unset it first with

workbooks("myAddin.xla").isaddin=false

do your stuff, then set it back to True.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[FrankE]

Thanks Bob.

Strange how difficult some things become if you don't work with the
for a couple of years.

Do you just remember things or use a Reference Book? If you do use
book, which one do you recommend?

Also, from your quote, do you actually live in Poole?

Regards
Fran

 

[Bob Phillips]

It's a pleasure Frank.

I mainly remember them. I have a reference book, John Green's Excel 2000 VBA
Programmer's Reference, but I rarely look at it these days, having scoured
it from front to back over the years. I do recommend it though, excellent
book.

And yes, I do live in Poole, right by the park. Do you know it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)