Re using same macro accross other spreadsheets

  • Thread starter Thread starter Harish_Sasikumar
  • Start date Start date
H

Harish_Sasikumar

Hi,

I have got a macro which needs to be used across 200 other
spreadsheets.In case of changes to the macro, I should be able to
change at one place and it should reflect on all the 200 spreadsheets.
Could someone please tell me the best possible way to do this.

Regards,
Harish
 
Save it in personal.xls workbook.

---------------------
Ms-Exl-Learner
---------------------





- Show quoted text -
Click to expand...

Thanks for the response,Using Personal.xls would activate the macro
for all the excels I use.I just want it to use for the intended
spreadsheets.
 
What do you mean by "all the Excels I use"?

Is a spreadsheet a workbook?

What do you mean by "activate the macro"?

Can't you re-write the macro to point to whatever workbook is active?


Gord Dibben MS Excel MVP
 
I have got more than 500 workbooks.all use the same macro.The problem
arises when I need to change something in the macro, I need to copy
and paste the macro in the editor of all the workbooks.
What do you mean by "all the Excels I use"?
Click to expand...
Harish: Its the set of workbooks I
Is a spreadsheet a workbook?
Click to expand...
Harish : Yes, its a separate workbook
What do you mean by "activate the macro"?
Click to expand...
Harish : basically, I want to call the same macro at all the
places.Even when there is a change in the macro, I should be able to
do it at one place and it should reflect in all the workbooks.
 
As Suggested I have created a personal.xlsm in XLSTART folder
Created the macro,Used hide to hide personal.xlsm spreadsheet.
Called the macro from the required spreadsheets using Application.Run
Application.Run "Personal.xlsm!<macro name>"

It works fine.

Thanks to all

-HS
 
Back
Top