Hi Jim

The OP say
I am actually trying your Example 2 from "Avoiding Two Versions" article.

There is only RibbonX in the add-in of that example


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jim Rech" wrote in message ...
It probably has a Sub Auto_Open in it. Auto_Open does not run when opened
by macro. It has to be forced to run:

Workbooks.Open "MyAddIns.xlam"
Workbooks("MyAddIns.xlam").RunAutoMacros xlAutoOpen

--
Jim
"joeeng" wrote in message
...
| It works when manually loading but not using code to open
|
| "Jim Rech" wrote:
|
| manually loading
| Workbooks("MyAddIns.xlam").open
|
| Which is it? Are you manually loading or using code?
|
| --
| Jim
| "joeeng" wrote in message
| ...
| |I was under the impression that manually loading .xlam files in Excel
2007
| |
| | i.e., Workbooks("MyAddIns.xlam").open
| |
| | would activate it as an add-in. It does not seem to be the case,
though.
| |
| | Am I missing something?
|
|