Hi,
I sent an Excel 2007 Macro Enabled file to someone, when they try to open it up and enable macros they get the following error message:
"The visual basic for applications (VBA) macros for this workbook are corrupted and has been deleted. The macros corruption most likely exists in the current file. To recover the macros, open up a backup copy of this file if you have one."
Any ideas? I tried it on seperate computers on my end and it works fine.
Thanks!
Hello pcsolutionsusa,
Welcome to the Forum!
If you provide more details about the system it failing on then we can probably give you some useful feedback.
- Which versions of Windows is being used?
- Which version Office is installed?
- Is the workbook on a network drive?
- Is the workbook received by email?
- Does this other machine have enough memory to open the workbook?
- Has the problem occurred when opening other workbooks?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
The problem turned out to be that VBA was not enabled during the original installation of Office/Excel 2007. Afer modifying the Office/Excel installation with Add/Remove Programs and enabling VBA, it worked great.
Thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks