Error when closing excel file without saving vba project separatel

A

Alex St-Pierre

Hi!
1) When I make a modification (ex: only add a line) inside a vba project,
and close vba without saving it and only save the excel file, I can't reopen
the excel file with the macro(excel error: must disable macro). (file size:
0.8m)
2)If I save the vba project and save the excel file, all works good at the
opening. (file size 1.4m)
I'm not familar with this kind of error. Is there a reason why the vba
cannot be compilate when I save only excel? Before last week, I never had
problem with this.
It seems to have a link between the file size and my error. If the file size
is 0.8m, I'm sure that I will get an error! Is there anything to add in the
problem to ensure the filesize will always be 1.4 even if I don't save the
vba project separately?
Does anyone has an idea ?
Thanks!
Alex
Note: I used Word library in the project but Word reference is always opened
(this is not new and worked well)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top