Home |
Search |
Today's Posts |
#1
|
|||
|
|||
open workbook automatically
I'm building a set of macro's. These macro I want to use in all different
worksheets. So I create a PERSONAL.XLS workbook which I save in XLSTART directory. As soon I have one file in this directory, when excel opens, the default blank workbook does not open anymore. What do I need to do to have the macro's available via Personal.Xls and still have the default Book1 opened automatically. The second problem I have is that I want to distribute these macro's to other persons within the company. The other people probably already have macro's in their Personal.XLS. What is the best way to distribute to multiple people macro's? |
#2
|
|||
|
|||
Hi Jo,
Hide your Personal.xls and close Excel, accepting the save prompt. When you re-open Excel, Personal.xls will open hidden and a blank workbook will be opened. Save the macros that you want to distribute in a new workbook. Open the VBE (Alt-F11), in the explorer window (Ctrl-R) select the workbook's ThisWorkbook module, open the properties window (F4) and change the value of the IsAddin property to True. Save the workbook (as 'Jo Coen Macros', say) , selecting the Microsoft Excel addin (*.xla) option in the file type option list. If your co-workers load the addin, your macros will be available to any workbook that they open. --- Regards, Norman "Jo Coen" <Jo wrote in message ... I'm building a set of macro's. These macro I want to use in all different worksheets. So I create a PERSONAL.XLS workbook which I save in XLSTART directory. As soon I have one file in this directory, when excel opens, the default blank workbook does not open anymore. What do I need to do to have the macro's available via Personal.Xls and still have the default Book1 opened automatically. The second problem I have is that I want to distribute these macro's to other persons within the company. The other people probably already have macro's in their Personal.XLS. What is the best way to distribute to multiple people macro's? |
#3
|
|||
|
|||
Maybe not according to all conventions, but if I have a bunch of macro's
that I want to use in all my workbooks, I save my file as .XLA and use it as an add-in, which still works quite well. "Jo Coen" <Jo schreef in bericht ... I'm building a set of macro's. These macro I want to use in all different worksheets. So I create a PERSONAL.XLS workbook which I save in XLSTART directory. As soon I have one file in this directory, when excel opens, the default blank workbook does not open anymore. What do I need to do to have the macro's available via Personal.Xls and still have the default Book1 opened automatically. The second problem I have is that I want to distribute these macro's to other persons within the company. The other people probably already have macro's in their Personal.XLS. What is the best way to distribute to multiple people macro's? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing unopened worksheet into an open Workbook | Excel Discussion (Misc queries) | |||
in Excel how do you set a workbook to only open on the first work. | Excel Discussion (Misc queries) | |||
Open Blank Workbook? | Excel Discussion (Misc queries) | |||
Open workbook to specific worksheet | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) |