Sometimes files are broken and beyond repair...can we prevent this?

[davidam]

I spent some time stressing this morning...feeling pretty confused about what I thought I knew about VBA. A file that I had moved here and there, changed, copied and used quite a bit, suddenly would not allow another file to copy data from it...it them threw a 'locked' error when VBA tried to just activate a sheet on the file. Fortunately, right at that moment, my daughter needed a ride so I took a break. As I was driving home it occurred to me the the file (and not me) was broken and it needed to be rebuilt. I did so and the problem was gone. It was a small file so it was easy to do; but if it had been a large one it would have been a different story. This begs the question: what can we do to prevent files from getting broke? A few things that I think are: saving files often and not running macros until the file has been saved. Any comments?

 

[xenou]

Hi,

I've never gotten a message that a sheet is "locked". So I'm just not sure what that really refers to. Have you "locked" any sheets, and if so, how did you do so? Do you mean that you are using cell protection? Are all the cells on the sheet locked?

(Not that it really matters if you've fixed it already by rebuilding the workbook).

ξ