Avatar of 1r3o2n8
1r3o2n8Flag for United States of America

asked on 

Some macros disappear when workbook is copied from DVR to HD on computer.

After developing a workbook on one computer, I copied it to a DVR- and then copied from that DVD to another HD but "some" of the macro pages are blank. Please tell me the secret.  One geek sugested using SAVE AS instead of copy and past or dragging.  I look forward to your answer.   rgds/ron
Microsoft ApplicationsMicrosoft Excel

Avatar of undefined
Last Comment
1r3o2n8
SOLUTION
Avatar of rspahitz
rspahitz
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of 1r3o2n8
1r3o2n8
Flag of United States of America image

ASKER

Attached is my wkbk  with macro1, macro2 & macro3 associated with acct no. order, beneficiary order, and originator order respectively.  The macros are now working but they are invisible, hidden or PW protected.  Can you help make my macros reappear?  I was also geting this error at one time but it has now disappeared:  "can't exit design mode because of Control "lable3" can not be created".I have about 100 copies of the workbook saved to DVD as I was devleoping.  All have the same macros missing.  Does that happen with copy and paste?  How do I prevent this from recurring?  I can end this session and start another with more points if you like.  Can I refer to this question by ID # whren I do that?  What's the bvest way?
PSBWIRE-2011---051411-1443.xlsm
Avatar of dlmille
dlmille
Flag of United States of America image

They appear to be there - 6 modules of code and there's code in each sheet.

Which macros are you missing?

Dave
Avatar of dlmille
dlmille
Flag of United States of America image

macro's 1-2-3 are there, too.

Let me ask a simple question.  When you are in the VBA Project Editor (ALT-F11) area, do you see the Project - VBA Project folder?

If you hit View tab then, Project Explorer, do the Excel Objects (where the sheets are listed) and Modules show up in that window?

Dave
Avatar of rspahitz
rspahitz
Flag of United States of America image

When I open it (Excel 2007) I'm told that there is a password (and I have to open it Read-Only.)
Other than that, Alt-F8 brings up Macros 1,2,3 and a collection of others.

I suspect that you're looking in the wrong place for the macros.
Try using Alt-F8 to list the macros, select one (e.g. macro1) and click on the Edit button to see where it takes you.  It should take you to the module called Module3Main and the Sub macro1.
Avatar of 1r3o2n8
1r3o2n8
Flag of United States of America image

ASKER

Thanks very much for your concerted effort on my behalf.  I found the solution based on both your ideas.  Sometimes I can't see the forest because of the trees.  
Your assistance was very much appreciated and done on a timely basis.  You have both halped me out in the past and I hope will continue.  rgds/ron
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo