Common module by multiple workbooks

  • Thread starter Thread starter S@S
  • Start date Start date
S

S@S

I have a number of workbooks (say 30) that all have one module wit
exactly the same code in them. Every time I make some changes in th
code, I have to update all workbooks.
*Is there a way to use one common module which will be someho
called/referenced by all workbooks?*

Thank
 
Save the code in your Personal.xls, which is saved in your xlstart folder.
If the file doesn't exist, create one. Whenever you open Excel, the
personal.xls file in folder xlstart will open and be hidden. However, you
can see it in the VB Editor projects. Any macro in your Personal.xls will
now be available for any open workbook to use.

Mike F
 
You must log in or register to reply here.

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

modules removing problem 2
Program Question for Dave peterson 2
VBA Macro to open excel file and replace VBA module with update 3
Add-in Question (common code) 2
non basic code in call stack 3
Import multiple workbooks to current workbook in specified row number 0
How to open correct Module window in VBE by macro 1
Does closing modules increase stability? 8

Back
Top