LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
GB GB is offline
external usenet poster
 
Posts: 230
Default workbook_beforeClose

For some reason, when closing excel, the code in my workbook_beforeClose
section (Located in "ThisWorkbook") does not run. I have the following
situation:
A personal.xls file located in my XLStart folder.
The file runs the workbook_Open routine when opened.
The only worksheet is hidden so that there is no associated worksheet for
the user to interact with.
Excel opens a separate workbook with the expected number of blank worksheets.
I can open, edit, and process other files on which I want to use the macros
in my personal.xls.
When closing excel by choosing the 'X' in the upper corner, all other
applications process properly, however the beforeclose event in my
personal.xls file does not get run. I have added a stop command in the code
to attempt debugging, and also a breakpoint as so desired, but it stops at
neither of these.

What is wrong with my logic?

There are some commands that I would like to process prior to closing the
personal.xls file and would have to come up with some other method if I can
not resolve this.

V/R,
GB
 
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
Workbook_BeforeClose Ed Davis[_2_] Excel Discussion (Misc queries) 21 September 26th 09 01:01 AM
Workbook_BeforeClose Andrzej Excel Programming 1 June 12th 05 10:01 PM
Workbook_BeforeClose PO Excel Programming 2 January 30th 05 05:07 PM
Workbook_BeforeClose Don Guillett[_4_] Excel Programming 1 August 31st 04 02:27 PM
Workbook_BeforeClose JimP Excel Programming 1 July 5th 04 10:39 PM


All times are GMT +1. The time now is 11:25 PM.

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"