Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 51
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create a macro that runs other macro in the same workbook VB Script for Excel Excel Programming 4 March 23rd 06 03:53 AM
Adding text to body of email with workbook attached. aph Excel Programming 3 December 5th 05 03:11 PM
Range of Cells to create body of email Hahndo Excel Worksheet Functions 1 September 26th 05 07:00 PM
Email Range of Cell Content to create subject and body from link Hahndo Excel Programming 2 September 23rd 05 11:46 PM
create new macro in new workbook Randy[_7_] Excel Programming 2 August 7th 03 05:50 PM


All times are GMT +1. The time now is 01:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"