Crashing Excel 2007


B

Buzz Mason

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
 
Ad

Advertisements

B

Buzz Mason

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top