Macro in body of workbook. Can I create XLA?
 

I've had some new SW installed on my system and now find that I have two
hidden XLS files with a macro in the body of the worksheet. I'd like to not
have these loaded unless I need them. Can I create an add-in? If not, is
there some way to automatically open these files when I need them? I
already am using a PERSONAL.XLS file so could add something to that.

Thanks in advance,
Barb Reinhardt

Macro in body of workbook. Can I create XLA?
 

Barb Reinhardt wrote:
I've had some new SW installed on my system and now find that I have two
hidden XLS files with a macro in the body of the worksheet. I'd like to not
have these loaded unless I need them. Can I create an add-in? If not, is
there some way to automatically open these files when I need them? I
already am using a PERSONAL.XLS file so could add something to that.

Thanks in advance,
Barb Reinhardt

Dear Barb Reinhardt,

You can add that to your PERSONAL.XLS and hide it so that you can use
only when required.



Regards
Thyagaraj

Macro in body of workbook. Can I create XLA?
 

Remember that Personal.xls is always loaded. Any file placed in the XLSTART
directory will open when Excel opens; that's where personal.xls is located,
and that's why it always opens. What makes the files always open? Are they
in XLSTART?

If the files are hidden, you can unhide them, using Excel's Windows menu.
You can then save them as add-ins if you want, but remember that an
installed add-in also is always open. You may not need or want them to be
add-ins.

If the files aren't too large and don't interfere with anything else, you
might just leave them in place. Otherwise, make shortcuts to the files on
your desktop, and launch the files from there when necessary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Barb Reinhardt" wrote in message
...
I've had some new SW installed on my system and now find that I have two
hidden XLS files with a macro in the body of the worksheet. I'd like to
not
have these loaded unless I need them. Can I create an add-in? If not,
is
there some way to automatically open these files when I need them? I
already am using a PERSONAL.XLS file so could add something to that.

Thanks in advance,
Barb Reinhardt

Macro in body of workbook. Can I create XLA?
 

I had some new software loaded on my computer and they were put into XLSTART.
Is there any way that I can get them to "hide" in my list of macros?
Thanks,
Barb


"Jon Peltier" wrote:

Remember that Personal.xls is always loaded. Any file placed in the XLSTART
directory will open when Excel opens; that's where personal.xls is located,
and that's why it always opens. What makes the files always open? Are they
in XLSTART?

If the files are hidden, you can unhide them, using Excel's Windows menu.
You can then save them as add-ins if you want, but remember that an
installed add-in also is always open. You may not need or want them to be
add-ins.

If the files aren't too large and don't interfere with anything else, you
might just leave them in place. Otherwise, make shortcuts to the files on
your desktop, and launch the files from there when necessary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Barb Reinhardt" wrote in message
...
I've had some new SW installed on my system and now find that I have two
hidden XLS files with a macro in the body of the worksheet. I'd like to
not
have these loaded unless I need them. Can I create an add-in? If not,
is
there some way to automatically open these files when I need them? I
already am using a PERSONAL.XLS file so could add something to that.

Thanks in advance,
Barb Reinhardt