View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Simon Lloyd[_184_] Simon Lloyd[_184_] is offline
external usenet poster
 
Posts: 1
Default 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