Computer Crash due to Macro-Enabled Sheet?

[mrcheatsheet]

Howdy, folks. Big fan of the board here and the help everyone gives. Usually, I can find anything I can think of on here without having to ask myself! But I did run across an issue today that you all may be able to help with...

I run a fantasy baseball website and give out a macro-enabled spreadsheet that pulls a lot of data, does all sorts of customizations and is updated frequently based on user inputs as they go through it. Needless to say, it's a pretty large file with all sorts of stuff going on. Today, one of the people using the sheet e-mailed me to let me know that their new computer crashed due to my sheet and it opened system files on their end... I'm confused as to how this would have happened. Here's his exact e-mail:

"The first issue I had was when I had the spreedsheet open and was browsing around with macros enabled. When I went to save it once my computer went haywire, with all these windows programs popping up. It was very weird... I had to completely restart my computer... The second time around I had the spreadsheet open, and was trying to watch a video in Youtube and it locked up on me and then I got the blue screen of death. Once again I had to restart."

I don't call up any files within my macros. And, I can't recreate the situation on a number of computers on my end. Any ideas of something within the workbook that may cause such problems? I'd hate to think it's happening to multiple people using my workbook.

One potential issue I thought of is that I have the file hosted within a Dropbox and he may have chose "open file" as opposed to "save file" when he accessed it from my site. I'm not sure if that would cause issues with the file being opened in a temporary folder if he did that.

Any ideas? Just trying to think how I want to tackle this. Thanks!

 

[mole999]

new, new PC, wonder what their anti virus status is.

was the file copied to their machine or where they trying to use it (if possible) across the internet

 

[woned]

To be honest if it only happened to one computer and he got a BSOD, I would say that the issue is on the person's computer, and not on your end.

 

[mrcheatsheet]

new, new PC, wonder what their anti virus status is.

was the file copied to their machine or where they trying to use it (if possible) across the internet

Yeah, not 100% sure exactly how new it is. But that certainly could be part of it.

I'm thinking he may have been using it across the internet. It's in a public Dropbox folder and he may have opened it instead of saving it to his machine. You think that may cause an issue? If so, I could give that warning somehow before they download it.

 

[mole999]

some of my files I have coded so that they can't be renamed without failing

Const XXX = "the book title.xls"                      '// Constant Book Title

Public Sub Cover()
    Workbooks(XXX).Worksheets("Cover").Visible = True ' or what

that also stops them working is opened in a temporary cache