File in Use Error Message

Y

ypukpete

I have designed a program which contains several userforms for adding and
retrieving data. It also has several pivot tables.
It was working OK for a time but now will not open and has the error warning..
File in Use: Locked for editing by ypukpete
It occasionally pops up and says File Error: Data may be lost.
I have looked thru the MS Help site and this site and cannot find a solution.
Fortunately I had a backup of an earlier version so all is not lost.
I would like to be able to delete the program (which it wont let me)
But more importantly find the cause so I can prevent it from happening again
Thanks for any help.
 
N

Nigel

Without seeing the code it is not easy to diagnose! Other than the program
has errors or the environment is corrupted.
 
Y

ypukpete

Yes... Nigel, that is one of the problems, I cant get back in to check the
code.
Could it be a userform that hasn't closed properly and is waiting for data.?
However, if I can't get into the code, I would just prefer to delete the
program.
It would be nice however to find out what the cause is.
Any help with this would be very much appreciated.
 
Top