ExcelBanter - how to store a macro to be available to all workbooks

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how to store a macro to be available to all workbooks (https://www.excelbanter.com/excel-programming/443949-how-store-macro-available-all-workbooks.html)

Andrew[_56_]

how to store a macro to be available to all workbooks

Hello,
If I write some VBA code and I want that particular module to be
visible to all workbooks, where do I save that module? Is there some
global repository?

thanks,
Andy

Walter Briscoe

how to store a macro to be available to all workbooks

In message
s.com of Fri, 26 Nov 2010 06:50:53 in microsoft.public.excel.programmin
g, Andrew writes
Hello,
If I write some VBA code and I want that particular module to be
visible to all workbooks, where do I save that module? Is there some
global repository?

thanks,
Andy

cf <http://www.rondebruin.nl/personal.htm
--
Walter Briscoe

Andrew[_56_]

how to store a macro to be available to all workbooks

On Nov 26, 8:38*am, Walter Briscoe
wrote:
In message
s.com of Fri, 26 Nov 2010 06:50:53 in microsoft.public.excel.programmin
g, Andrew writes

Hello,
If I write some VBA code and I want that particular module to be
visible to all workbooks, where do I save that module? *Is there some
global repository?

thanks,
Andy

cf <http://www.rondebruin.nl/personal.htm
--
Walter Briscoe

thank you

All times are GMT +1. The time now is 04:49 PM.