Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Crashing Excel 2007
Hi All
I am running Excel 2007 with all the latest updates etc (31/10/08) I am trying to solve the following issue... I have a worksheet that has a clipart image of a folder inserted and a macro attached to it. The macro is very simple: Sub test() ThisWorkbook.Close savechanges:=False End Sub When I click on the image, excel close but with the following message "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience." If I have another Excel workbook open and click on the image then the workbook close normally. If I use a Button instead of the image I do NOT get the problem and Excel closes normally. I have tried the same with shapes, pictures etc and all have the crashing issue. I have posted this issue on other forums but nobody has managed to come up with a solution. Please can someone help me€¦. This is part of a large project I develop for one of my customers. I originally developed this in Excel 2003 and am now converting everything to Excel 2007 because my customer is converting to Excel 2007 in 2009 When I run the 2003 version it works fine, when I run the 2003 version in 2007 under €ścompatibility mode€ť it crashes. I would be grateful of any ideas Thank you -- Buzz CBM-Logix Ltd Italy 54027 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Crashing Excel 2007
HI ALL
OK please ignore this post... I found the solution in Jim Rech reply to Misbah's post "Crash on ActiveWindow.close" It worked VERY well Thanks for looking at this post anyway... It should teach me to search further before posting ;-) Cheers -- Buzz CBM-Logix Ltd Italy 54027 "Buzz Mason" wrote: Hi All I am running Excel 2007 with all the latest updates etc (31/10/08) I am trying to solve the following issue... I have a worksheet that has a clipart image of a folder inserted and a macro attached to it. The macro is very simple: Sub test() ThisWorkbook.Close savechanges:=False End Sub When I click on the image, excel close but with the following message "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience." If I have another Excel workbook open and click on the image then the workbook close normally. If I use a Button instead of the image I do NOT get the problem and Excel closes normally. I have tried the same with shapes, pictures etc and all have the crashing issue. I have posted this issue on other forums but nobody has managed to come up with a solution. Please can someone help me€¦. This is part of a large project I develop for one of my customers. I originally developed this in Excel 2003 and am now converting everything to Excel 2007 because my customer is converting to Excel 2007 in 2009 When I run the 2003 version it works fine, when I run the 2003 version in 2007 under €ścompatibility mode€ť it crashes. I would be grateful of any ideas Thank you -- Buzz CBM-Logix Ltd Italy 54027 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Crashing Problem | Charts and Charting in Excel | |||
Excel 2007 Crashing Problem | Charts and Charting in Excel | |||
Excel 2007 Crashing Problem | Charts and Charting in Excel | |||
Crashing Bug in Solver.XLAM for Excel 2007??? | Excel Programming | |||
Excel 2007 Crashing | Excel Discussion (Misc queries) |