ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Move macro to Personal.xls (https://www.excelbanter.com/excel-programming/440325-move-macro-personal-xls.html)

newbie

Move macro to Personal.xls
 
How do I move a macro from a workbook to Personal.xls?
--
newbie

Chip Pearson

Move macro to Personal.xls
 
If you want to move the entire module, you can drag and drop the
module from one workbook into another in the Project window of the VBA
editor. If you want only one procedure, just use copy and paste.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Sat, 6 Mar 2010 09:56:05 -0800, newbie
wrote:

How do I move a macro from a workbook to Personal.xls?


newbie

Move macro to Personal.xls
 
Thank you.
--
newbie


"Chip Pearson" wrote:

If you want to move the entire module, you can drag and drop the
module from one workbook into another in the Project window of the VBA
editor. If you want only one procedure, just use copy and paste.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Sat, 6 Mar 2010 09:56:05 -0800, newbie
wrote:

How do I move a macro from a workbook to Personal.xls?

.



All times are GMT +1. The time now is 12:39 PM.

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