is it possible to have a common macro for Multiple workbook

  • Thread starter Thread starter Avi
  • Start date Start date
A

Avi

Hi,

I have more than 10 workbook with exactly same VBA code.

The challange I am facing is - When I change something in one Macro, I
need to update all the macro. Kindly suggest me a way around to avoid
this, something like having a common macro file, which is shared among
10 workbooks or something similar to that.

Thanks in advance,
Avinash
 
Save your macros in PERSONAL.XLS or make an addin (...xla). Search google or
help for further instructions.
 
hi
at the top on discussion's page is a search box. type in personal.xls. to
the far right, click the go button. you will find a wealth of information on
this subject. check the dates beside the posts. your question has been asked
many times, in many ways.

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for all Excel Workbooks to print to PDF 2
How to Unlock Excel Workbook protected by MACRO Password 6
Macros to extract data frommultiple workbooks to a master workbook 0
Macros for Printing multiple workbooks 2
Create a workbook with macros from inside another macro 1
Common set of macros 3
How to apply a macro to all workbooks 2
Macro code for clicking on Command Button in another workbook 7

Back
Top