Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create a macro that runs other macro in the same workbook | Excel Programming | |||
Adding text to body of email with workbook attached. | Excel Programming | |||
Range of Cells to create body of email | Excel Worksheet Functions | |||
Email Range of Cell Content to create subject and body from link | Excel Programming | |||
create new macro in new workbook | Excel Programming |