corrupted sheet

[handysmurf]

I have a workbook that has become corrupted. Coincidentally 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]

post link to this shared file and we will see what we can do for you

 

[JoeMo]

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]

https://drive.google.com/open?id=1Hq-E6KlDm01U3WYRPU5LgznwQe-1mDOb

 

[handysmurf]

I tried going into VBA and it just sat there doing nothing for 10 minutes, save for the little circle thing.

 

[MoshiM]

I tried going into VBA and it just sat there doing nothing for 10 minutes, save for the little circle thing.

Have you tried disabling macros first?

 

[sandy666]

try this

download

all macros are commented

 

[handysmurf]

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.