Personal.xls
 

Hey guys...I have a problem. I'm trying to pull up an old macro that
think I stored in Personal.XLS on an old CpU. I think I rename
Personal.xls and put it under my docs. It is now on my new cpu. Th
macro runs if I open the workbook (but the workbook doesn't open).
would like to consolidate all of my macros and leave them under my ne
Personal.xls. The problem is that when I try to edit the one I a
talking about (so that I can copy it), I get the error message: "Canno
edit a macro on a hidden workbook. Unhide the workbook using the unhid
command." Thanks for any help

--
Message posted from http://www.ExcelForum.com

Personal.xls
 

You can drop and drag modules, not individual macros, from one
project to another.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Scottmk " wrote in
message ...
One more thing, which i honestly don't know....What is the best
way to
transfer macros from workbooks to the Personal.xls. Copy and
paste, or
can you drag them in?


---
Message posted from http://www.ExcelForum.com/

Personal.xls
 

Copy and paste is pretty straight-forward, but you could even export the
module from the old workbook, and import to the new.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Scottmk " wrote in message
...
One more thing, which i honestly don't know....What is the best way to
transfer macros from workbooks to the Personal.xls. Copy and paste, or
can you drag them in?


---
Message posted from http://www.ExcelForum.com/