Yesterday my codes were fine..but when I opened it today it instantly
said "Automation error" as when I open the VB editor..
when I save the file it says Document not saved...I tried to look
for some solutions..some told about: network problems(I tried
disconnecting in our network), out of memory or harddisk space(I still
have a lot of space and only the excel file is open on my desktop...for
anti-virus I had disabled it...please help me It's really weird..when I
open my file on other pc they can save it and there are no errors..I
also tried to copy the sheets on other workbook and renamed it, it
worked once but after another coding and saving the error occurs
again...what can I do about this..please help

I tried removing my form and the document saved just fine...how can I
use again the userform I created...please help..