ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to get a macro to work in different workbooks ? (https://www.excelbanter.com/excel-programming/331650-re-how-get-macro-work-different-workbooks.html)

rjamison

How to get a macro to work in different workbooks ?
 
Hi
Store your macros into a personnal.xls workbook hide its window, save
and
place this workbook in the Excel Startup folder.
This will allow your macros to be available each time you open Excel.

HTH
Cordially
Pascal


"Susanne" a écrit dans le message de

...

Hi

How do I get a macro to work in different workbooks without having to

copy
it in to every workbook. I have tried to create a button on the

toolbar

but

it does not work.

Susanne




All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com