Hi All
attached is my userform spreadsheet
If I put this on a network folder, (which I have access to), then share the workbook, when I open it, excel crashes?
If I dont share it, excel doesn't crash and the userform opens fine
Only crashes when saved(shared) when I attempt to open the userform?
I cant for the life of me figure out why? any ideas?
Many thanks
Last edited by techteam; 04-02-2012 at 09:28 AM.
I tried it in Shaered mode and it works fine.
Can you try it as shared and save it on a local drive?
which line exactly cause the error??
Regards,
Khaled Elshaer
www.BIMcentre.com
Remember To Do the Following....
- Thank those who have helped you by clicking the Star below their post.
- Mark your post SOLVED if it has been answered satisfactorily:
- Select Thread Tools (on top of your 1st post)
- Select Mark this thread as Solved
Hi Kelshaer
Thanks for your response..
So, it seems to be when the userform actually opens it doesnt like.
The two bits of code are in the Workbook_open...
And the same code in the module (for the buttons)...
Please Login or Register to view this content.
I was wondering maybe it has something to do with the UserForm_Initialize() code? but i couldn't see why it would be?Please Login or Register to view this content.
Same problem happens when I save it as shared on a local drive too
OK So, just did a bit more testing
This is what I did:
1. Put the file on the shared drive
2. Shared the file (which automatically saves it)
3. Closed down excel
4. Re-opened excel
5. Userform opened
6. I then saved the workbook (ctrl+S)
7. Closed down excel
8. Re-open excel
9. Crashes
Its as if it only crashes for the person that last saved the workbook?
Use the attached file.
It was fixed
I save your file to the network drive... But when I open it now the file still crashes
Minor changes.
Please try this one
No joy i'm afriad
Tried it on a local drive too, just doesnt seem to want to open
I really appreciate your help with this though
Do you think it could be because there's just too much coding?
no.
I realy can't know what is going wrong. sorry.
Ok, well thank you for trying
I've only had a quick look at the file but
- shared workbooks are famous for this sort of weird behavior. everyone says don't use them
- your project doesn't actually compile - you have syntax errors, certainly in the startup form.
- you have a lot of forms that look pretty much identical. no real need for that. - just use one and change it at runtime.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks