.xla placed in XLStart folder shows up as 'default' book.

[Roy]

Microsoft says: "Add-ins (.xla files) that you put in a startup folder do
not typically appear when you start Excel. The add-ins are loaded in memory.
The add-ins run any auto macros."

Well, my .xla add-in does appear as the 'initial' default spreadsheet
(instead of 'Book1', which used to, and what I am sure is supposed to,
appear.)

How can I 'hide' the .xla and give my end user a 'clean' Book 1?

 

[Dave Peterson]

Addins are hidden from the user.

So I'm guessing that you're either not saving the file as an addin (maybe just a
normal workbook with the .xla extension). Or you've got another workbook that
has a very similar name (like RaysAddin.xlS).

I'd check that XLStart folder (in fact all of them!) for extra files and resave
your addin doublechecking that it is indeed an addin (Save As Type box).

 

[Roy]

Aha!! It worked. I thought I could just rename it to an xla file (which is
what I had done). (That works in Word.) But I see that the file must
affirmatively be saved-as as an .xla file. That did the trick. Thanks for
your help.

roy

 

[Chip Pearson]

I believe that you can convert a workbook to an add-in by changing the
file extension to 'xla' AND setting the IsAddIn property to True.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]

Aha!! It worked. I thought I could just rename it to an xla file (which is
what I had done). (That works in Word.) But I see that the file must
affirmatively be saved-as as an .xla file. That did the trick. Thanks for
your help.

roy

 

[Roy]

Two things:
(1) Where is this "IsAddIn" property. I went to the Project Properties and
that is not one of the choices.
(2) Once it is an AddIn, how can I make the worksheet visible. I can edit in
VBA code, but I cannot 'see' it otherwise. I want to create a ToolBar to run
some of the code by clicking on a menu and using my mouse, but the menu I
create is not attached to the AddIn, but rather to the 'normal' (or whatever
the normal.dot equivalent in Excel is"

I believe that you can convert a workbook to an add-in by changing the
file extension to 'xla' AND setting the IsAddIn property to True.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]

 

[Dave Peterson]

Inside the VBE:
Show the Project Explorer (ctrl-r)
Select your project
Expand the branches so that you then select the ThisWorkbook object
Show the properties window (F4 will work)
You'll see an IsAddin property that you can change.

You can also do this using a line of code.

In the immediate window (ctrl-g)
workbooks("RoysAddin.xla").isaddin = true

or in a procedure in a general module in that workbook (say):

Option Explicit
Sub Testme()
thisworkbook.isaddin = true
end sub

======
Once the workbook is marked as an addin, the workbook's windows are hidden.
That means that each sheet will be hidden, too.

You can toggle the .isaddin property to false to see the worksheet.

But I wouldn't do that.

Saved from a previous post:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

And Bob Phillips shows a way to use a wrapper so that it can work in both xl2003
and xl2007.
http://msmvps.com/blogs/xldynamic/archive/2010/03/27/deploy-me-simple.aspx

Two things:
(1) Where is this "IsAddIn" property. I went to the Project Properties and
that is not one of the choices.
(2) Once it is an AddIn, how can I make the worksheet visible. I can edit in
VBA code, but I cannot 'see' it otherwise. I want to create a ToolBar to run
some of the code by clicking on a menu and using my mouse, but the menu I
create is not attached to the AddIn, but rather to the 'normal' (or whatever
the normal.dot equivalent in Excel is"

I believe that you can convert a workbook to an add-in by changing the
file extension to 'xla' AND setting the IsAddIn property to True.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]

Aha!! It worked. I thought I could just rename it to an xla file (which is
what I had done). (That works in Word.) But I see that the file must
affirmatively be saved-as as an .xla file. That did the trick. Thanks for
your help.

roy





Addins are hidden from the user.

So I'm guessing that you're either not saving the file as an addin
(maybe
just a normal workbook with the .xla extension). Or you've got another
workbook that has a very similar name (like RaysAddin.xlS).

I'd check that XLStart folder (in fact all of them!) for extra files and
resave your addin doublechecking that it is indeed an addin (Save As
Type
box).


Roy wrote:


Microsoft says: "Add-ins (.xla files) that you put in a startup folder
do
not typically appear when you start Excel. The add-ins are loaded in
memory. The add-ins run any auto macros."

Well, my .xla add-in does appear as the 'initial' default spreadsheet
(instead of 'Book1', which used to, and what I am sure is supposed to,
appear.)

How can I 'hide' the .xla and give my end user a 'clean' Book 1?

 

[Roy]

Got it. It works. Thanks!!!

Inside the VBE:
Show the Project Explorer (ctrl-r)
Select your project
Expand the branches so that you then select the ThisWorkbook object
Show the properties window (F4 will work)
You'll see an IsAddin property that you can change.

You can also do this using a line of code.

In the immediate window (ctrl-g)
workbooks("RoysAddin.xla").isaddin = true

or in a procedure in a general module in that workbook (say):

Option Explicit
Sub Testme()
thisworkbook.isaddin = true
end sub

======
Once the workbook is marked as an addin, the workbook's windows are
hidden. That means that each sheet will be hidden, too.

You can toggle the .isaddin property to false to see the worksheet.

But I wouldn't do that.

Saved from a previous post:

For additions to the worksheet menu bar, I really like the way John
Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the
addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de
Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved
as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

And Bob Phillips shows a way to use a wrapper so that it can work in both
xl2003
and xl2007.
http://msmvps.com/blogs/xldynamic/archive/2010/03/27/deploy-me-simple.aspx

Two things:
(1) Where is this "IsAddIn" property. I went to the Project Properties
and that is not one of the choices.
(2) Once it is an AddIn, how can I make the worksheet visible. I can edit
in VBA code, but I cannot 'see' it otherwise. I want to create a ToolBar
to run some of the code by clicking on a menu and using my mouse, but the
menu I create is not attached to the AddIn, but rather to the 'normal'
(or whatever the normal.dot equivalent in Excel is"

I believe that you can convert a workbook to an add-in by changing the
file extension to 'xla' AND setting the IsAddIn property to True.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]




Aha!! It worked. I thought I could just rename it to an xla file (which
is
what I had done). (That works in Word.) But I see that the file must
affirmatively be saved-as as an .xla file. That did the trick. Thanks
for
your help.

roy





Addins are hidden from the user.

So I'm guessing that you're either not saving the file as an addin
(maybe
just a normal workbook with the .xla extension). Or you've got another
workbook that has a very similar name (like RaysAddin.xlS).

I'd check that XLStart folder (in fact all of them!) for extra files
and
resave your addin doublechecking that it is indeed an addin (Save As
Type
box).


Roy wrote:


Microsoft says: "Add-ins (.xla files) that you put in a startup folder
do
not typically appear when you start Excel. The add-ins are loaded in
memory. The add-ins run any auto macros."

Well, my .xla add-in does appear as the 'initial' default spreadsheet
(instead of 'Book1', which used to, and what I am sure is supposed to,
appear.)

How can I 'hide' the .xla and give my end user a 'clean' Book 1?