ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   save macro to personal.xls. (https://www.excelbanter.com/excel-programming/303666-save-macro-personal-xls.html)

André

save macro to personal.xls.
 
i messed up and saved a macro as "this workbook" rather
then the personal.xls, is there a way to move it into
personal.xls?

A.

Don Guillett[_4_]

save macro to personal.xls.
 
Did you try a simple copy/paste?

--
Don Guillett
SalesAid Software

"André" wrote in message
...
i messed up and saved a macro as "this workbook" rather
then the personal.xls, is there a way to move it into
personal.xls?

A.




André

save macro to personal.xls.
 
Just the code you mean?

if so, is it as simple as cutting and pasteing?

A.

-----Original Message-----
Did you try a simple copy/paste?

--
Don Guillett
SalesAid Software

"André" wrote in

message
...
i messed up and saved a macro as "this workbook" rather
then the personal.xls, is there a way to move it into
personal.xls?

A.



.


Don Guillett[_4_]

save macro to personal.xls.
 
Yes, just copy your code from the source module and paste in the destination
module. Simple.

--
Don Guillett
SalesAid Software

"André" wrote in message
...
Just the code you mean?

if so, is it as simple as cutting and pasteing?

A.

-----Original Message-----
Did you try a simple copy/paste?

--
Don Guillett
SalesAid Software

"André" wrote in

message
...
i messed up and saved a macro as "this workbook" rather
then the personal.xls, is there a way to move it into
personal.xls?

A.



.




Dave Peterson[_3_]

save macro to personal.xls.
 
Yep.

And if you get prompted for having macros in the old workbook (even though you
cut them out), a visit to Debra Dalgleish's site will help:
http://www.contextures.com/xlfaqMac.html#NoMacros

André wrote:

Just the code you mean?

if so, is it as simple as cutting and pasteing?

A.

-----Original Message-----
Did you try a simple copy/paste?

--
Don Guillett
SalesAid Software

"André" wrote in

message
...
i messed up and saved a macro as "this workbook" rather
then the personal.xls, is there a way to move it into
personal.xls?

A.



.


--

Dave Peterson



All times are GMT +1. The time now is 09:17 PM.

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