ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   XL 2003 and Personal.xls (https://www.excelbanter.com/excel-discussion-misc-queries/74298-xl-2003-personal-xls.html)

b&s

XL 2003 and Personal.xls
 
At (my) XL 2003 "Private Sub Workbook_BeforeClose(Cancel As Boolean)"
does not work only in Personal.xls. Tested on 2 machines. Any advice?

--
regards/pozdrav!
Berislav





Jim Rech

XL 2003 and Personal.xls
 
You might try using Sub Auto_Close instead.

--
Jim
"b&s" wrote in message
...
| At (my) XL 2003 "Private Sub Workbook_BeforeClose(Cancel As Boolean)"
| does not work only in Personal.xls. Tested on 2 machines. Any advice?
|
| --
| regards/pozdrav!
| Berislav
|
|
|
|



b&s

XL 2003 and Personal.xls
 
Thank you for responding...
I'm just curious why "Sub Workbook_BeforeClose" in Personal.xls works at
XL97 and does not at XL2003.

--
Berislav

Jim Rech wrote:
You might try using Sub Auto_Close instead.

At (my) XL 2003 "Private Sub Workbook_BeforeClose(Cancel As Boolean)"
does not work only in Personal.xls. Tested on 2 machines. Any advice?

--
regards/pozdrav!
Berislav






All times are GMT +1. The time now is 07:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com