Hey guys
I have a large userform on a large spreadsheet. The initialize code is quite long, but it's fine (I think).
The file sits on a server and on my computer I can open the file and click a button to open up the userform perfectly fine - absolutely no problems.
As soon as someone else who is logged onto the server tries to open the same file (I don't have it open at this point) on a different computer, and clicks the same button to open the userform.... excel crashes completely.
The excel file itself has been built on my computer for the past several months and the only way I can explain why this is happening is:
The file works perfectly on the computer it was built on and doesn't perform on computers its not used to.
I know this is complete rubbish, but I just don't know what is going on here.
I was wondering if there were any quick fixes that may help?
Note, I haven't tried opening the file on a local pc. In other words, the file has only ever been opened on our server and not directly on/from a computer hard drive.
Huge thanks
Bookmarks