Opening VBA File Error. how to fix this?

[MonioDee]

Hi Mentors hope someone could help fix my problem, I cant upload my file here coz it was 2.59 MB size and i dont have idea how it does, but when I converted it into xlsb file it was 492 kb only, and my maor problem is when it was in xlsm file i cant open it properly and pictures below keep on going, how to fix this guys! but good thing it works perfectly in xlsb file. thanks Mentors for the postive response thanks!!!! ^_^

 

[Hui]

Can you upload the XLSB version ?

You have backups ?

After you repair it, what is missing ?

 

[MonioDee]

here it is sir Hui, yet I dont have idea sir if there is something really are missing, but the last time I use it, it was perfectly fine, by the way Sir what's the difference between xlsb & xlsm, my apology Sir coz Im still a newbie I just rely on internet resources, Thanks a lot Sir, have a greatest day!!!

 

[SirJB7]

Hi, MonioDee!
Opened your uploaded file without any issue. If you're wondering about the difference between sizes of .xlsm and .xlsb, don't worry about it, .xslb format files are lighter than .xlsm while keeping the same features.
Regards!

 

[MonioDee]

Thank you for the info SirJB! but if we convert it into xlsm in that format the errors arises, anyways sir if there is no difference between xlsm and xlsb ill stick with xlsb same features but lighter size , thanks a lot Mentors. ^_^

 

[SirJB7]

Hi, MonioDee!
As Hui asked you, do you have backups of the original .xlsm file?
Regards!

 

[Chihiro]

xlsb is binary format. Read post in thread below for some details (and also MarcL's posts below it).

http://chandoo.org/forum/threads/data-validation-drop-box-using-index-formula.29294/#post-175288

 

[MonioDee]

My apology for late response Mentors, im afraid but I dont have any back-up of it that is why, ^_^ thats all I have, anyways mentors thank you so much for the help, you were all the best have a great day everyone!!