Personal.xls

  • Thread starter Thread starter Scottmk
  • Start date Start date
S

Scottmk

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
 
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
 
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)
 
Back
Top