Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to put code for access by all workbooks
Please can someone explain where to put code these days that is then
available to all new workbooks. I have a 'Personal.XLS' file but none of my other colleagues have; do I create such a workbook for them? Any help would be much appreciated please. PS - it's Excel 2002/XP. Cheers David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to put code for access by all workbooks
Yes, you should probably create a Personal Macro Workbook for all your
users. -- Vasant "David Smith" wrote in message ... Please can someone explain where to put code these days that is then available to all new workbooks. I have a 'Personal.XLS' file but none of my other colleagues have; do I create such a workbook for them? Any help would be much appreciated please. PS - it's Excel 2002/XP. Cheers David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to put code for access by all workbooks
David
I would place the macros in a workbook and save it as an add-in(*.xla) and give copies of that to your colleagues. They could store in Office\Library folder and load it in ToolsAdd-ins. Best to leave them with the capability of creating their own Personal.xls for their own personal macros. Also, add-ins don't need the workbook name when assigning macros to a button or menu item. Gord Dibben Excel MVP "David Smith" wrote in message ... Please can someone explain where to put code these days that is then available to all new workbooks. I have a 'Personal.XLS' file but none of my other colleagues have; do I create such a workbook for them? Any help would be much appreciated please. PS - it's Excel 2002/XP. Cheers David |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to put code for access by all workbooks
Better solution than mine, Gord.
Regards, Vasant. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... David I would place the macros in a workbook and save it as an add-in(*.xla) and give copies of that to your colleagues. They could store in Office\Library folder and load it in ToolsAdd-ins. Best to leave them with the capability of creating their own Personal.xls for their own personal macros. Also, add-ins don't need the workbook name when assigning macros to a button or menu item. Gord Dibben Excel MVP "David Smith" wrote in message ... Please can someone explain where to put code these days that is then available to all new workbooks. I have a 'Personal.XLS' file but none of my other colleagues have; do I create such a workbook for them? Any help would be much appreciated please. PS - it's Excel 2002/XP. Cheers David |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to put code for access by all workbooks
Just an alternative Vasant.
Depends on the users' knowledge and capabilities. Gord On Fri, 27 Feb 2004 19:21:14 -0500, "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote: Better solution than mine, Gord. Regards, Vasant. "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . David I would place the macros in a workbook and save it as an add-in(*.xla) and give copies of that to your colleagues. They could store in Office\Library folder and load it in ToolsAdd-ins. Best to leave them with the capability of creating their own Personal.xls for their own personal macros. Also, add-ins don't need the workbook name when assigning macros to a button or menu item. Gord Dibben Excel MVP "David Smith" wrote in message ... Please can someone explain where to put code these days that is then available to all new workbooks. I have a 'Personal.XLS' file but none of my other colleagues have; do I create such a workbook for them? Any help would be much appreciated please. PS - it's Excel 2002/XP. Cheers David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export Data from many workbooks with many sheets to Access | Excel Discussion (Misc queries) | |||
Access log of previously worked on workbooks | Excel Discussion (Misc queries) | |||
Sharing workbooks - user access | Excel Discussion (Misc queries) | |||
Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
Access Closed workbooks (2003) | Excel Worksheet Functions |