ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using Macro in Several Excel Workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/228082-using-macro-several-excel-workbooks.html)

Semicolumn

Using Macro in Several Excel Workbooks
 
Hi;
i wrote a macro in one excel workbook and want to use this macro in all of
workbooks.
i beleive that there is away to do that.
--
Semicolumn

Simon Lloyd[_184_]

Using Macro in Several Excel Workbooks
 

Semicolumn;313062 Wrote:
Hi;
i wrote a macro in one excel workbook and want to use this macro in all
of
workbooks.
i beleive that there is away to do that.
--
SemicolumnWhen storing a macro for use in all workbooks you need to create/store

the macro in PERSONAL.xls any macro that resides there wil be available
in all your other workbooks.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=87520



All times are GMT +1. The time now is 02:22 PM.

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