corrupted sheet

handysmurf

Board Regular
Joined
Jan 17, 2015
Messages
63
I have a workbook that has become corrupted. Coincidentally :rolleyes: at the precise same moment microsoft decided to remind me to update my payment method. Anyway, I can open the workbook but it closes when I attempt to access my macros. I can (begrudgingly) rebuild my macros but is there another option?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,850
post link to this shared file and we will see what we can do for you
 
Last edited:

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,669
If you can open the workbook and access the VBE (Alt+F11), you can export the macros as .bas files (VBE>Files>Export), then import them to a new workbook.
 

handysmurf

Board Regular
Joined
Jan 17, 2015
Messages
63
I tried going into VBA and it just sat there doing nothing for 10 minutes, save for the little circle thing.
 

handysmurf

Board Regular
Joined
Jan 17, 2015
Messages
63
No I had not tried that. I downloaded the file in which sandy666 had remarked every line in the macros. I unremarked them one by one. For whatever reason that worked with no problems.
 

Forum statistics

Threads
1,082,569
Messages
5,366,360
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top