Hi,
i have 4 active X buttons on a sheet, all work okay apart from 1.
this is the code
on clicking the button it causes Excel to crash and restart.
Please Login or Register to view this content.
i have tried assigning the code to a sub and then call that from the button and it works ok
Please Login or Register to view this content.Any ideas?Please Login or Register to view this content.
I have tried deleting the button and adding a new one but it still happens.
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
This MAY be related to a known issue that arose after microsoft released an update. Try going to C:\Users\[user name]\AppData\Local\Temp\Word8.0 and C:\Users\[user name]\AppData\Local\Temp\Excel8.0 and in both cases find the file called "MSForms.exd" and delete.
Thanks but that issue caused active x buttons not to work. The buttons work fine but it just crashes if the code is within the command_click sub.
Hello Sean Thomas,
Since this is an API related problem, I will need to see your all of your code.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith, unfortunately it is work related and highly confidential so I can't upload the workbook. All the API code etc works fine if I run the rungetdatafromwindows procedure. But it crashes if I build the code into the button sub. I also had a problem with the workbook_open sub, it failed on sheet4.unprotect. I had to delete that line and rewrite it to clear the fault. I'm wondering if the workbook has been corrupted as the command_click should not cause this error.
Hello Sean Thomas,
Sorry to hear that. I really need to review all of the code to find the problem. The Windows API is very complex and it is easy to make a mistake when using it. Without being able to review the code in it's entirety, I can help you troubleshoot this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks