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

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

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

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

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