LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Crash on ActiveWindow.Close

Hi,

Excel 2007 application crahses, when I click one of my graphic buttons (on
my Excel front-end) to call an assigned macro that is being used with the
intent to close the workbook and exit from Excel. I have tried using
ActiveWindow.Close, ActiveWorkbook.Close and ThisWorkbook.Close; but all of
them result in crashing excel.

When I call the same macro somewhere else (and not at the click of graphics
button), it closes the active workbook fine (without falling over). The
problem is consistent whenever, I call that macro graphics button click
event. It was not the case with earlier versions (such as Excel 2003).

Certainly, the plan is not to use Excel form buttons or Visual Basic buttons
(as alternatives) to proceed with the task. Graphics buttons provide great
look and feel to end-users (that is why, I am persisting on these buttons).

Is there a limitation in using graphics buttons in such a way (that I am
using)? I have not found much in the Internet. Could anyone please help me in
this regard? I would be obliged.

Regards,
Misbah
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel crash reload close 302blue_eyes Excel Discussion (Misc queries) 5 April 10th 08 01:44 PM
crash on close Matt Excel Programming 15 April 25th 07 05:58 PM
How to get ActiveWindow [email protected][_2_] Excel Programming 5 January 26th 07 04:09 AM
Excel.ActiveWindow Is Excel.ActiveWindow Returns False Neal Andrews Excel Programming 1 October 26th 06 11:10 AM
ActiveWindow VBA problem Tomasz Klim[_2_] Excel Programming 2 June 11th 06 11:04 PM


All times are GMT +1. The time now is 03:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"