Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 19
Default Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work

Please help...

I'm tyring to use the Workbook_BeforeClose event in an Excel 2007
ThisWorkbook object. When the code sets the Cancel parameter to "True", the
workbook isn't supposed to close. For testing purposes, I used the following
code on several computers:


Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
End Sub

On my home computer, and others at work, the code works fine (the workbook
won't close). On some work computers, including my own, the workbook closes.
This is very frustrating.

All computers are using the same operating system; Windows XP Professional
Version 2002 SP3 and the same software; Office 2007 SP2 with Microsoft Office
Excel 2007 (12.0.6425.1000) SP2 MSO (12.0.6425.1000).

I don't want to uninstall and reinstall Office 2007 to try and correct the
issue becuase my local TSE at work doesn't want to have to do this to several
computers that are having the issue. He would rather find out what is
causing the issue and post a fix on the server for the users to install.

I've researched for hours on end trying to find out what might be causing
this but came up with nothing. I called Microsoft to see if they could help
but all they want to do is charge me $260 for an incident ticket. I'm upset
about that because the software was only installed on my computer in January
2009 and others, less than 2 weeks ago. I would expect a warranty to cover
the cost. They said that because the issue is occuring on computers
connected to a network and involves a macro, they have to charge for
Professional support.

Can anyone out there help?

Thanks for listening,

GPMichal
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 19
Default Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work

Please diregard. I posted this question in Microsoft.Pubic.Excel.Programming
instead.

"gpmichal" wrote:

Please help...

I'm tyring to use the Workbook_BeforeClose event in an Excel 2007
ThisWorkbook object. When the code sets the Cancel parameter to "True", the
workbook isn't supposed to close. For testing purposes, I used the following
code on several computers:


Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
End Sub

On my home computer, and others at work, the code works fine (the workbook
won't close). On some work computers, including my own, the workbook closes.
This is very frustrating.

All computers are using the same operating system; Windows XP Professional
Version 2002 SP3 and the same software; Office 2007 SP2 with Microsoft Office
Excel 2007 (12.0.6425.1000) SP2 MSO (12.0.6425.1000).

I don't want to uninstall and reinstall Office 2007 to try and correct the
issue becuase my local TSE at work doesn't want to have to do this to several
computers that are having the issue. He would rather find out what is
causing the issue and post a fix on the server for the users to install.

I've researched for hours on end trying to find out what might be causing
this but came up with nothing. I called Microsoft to see if they could help
but all they want to do is charge me $260 for an incident ticket. I'm upset
about that because the software was only installed on my computer in January
2009 and others, less than 2 weeks ago. I would expect a warranty to cover
the cost. They said that because the issue is occuring on computers
connected to a network and involves a macro, they have to charge for
Professional support.

Can anyone out there help?

Thanks for listening,

GPMichal

Reply
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
OK/Cancel box functionality? sycsummit Excel Discussion (Misc queries) 1 February 11th 09 05:59 PM
cancel save lawson Excel Discussion (Misc queries) 1 October 11th 07 11:00 PM
Can't get Cancel to work in message box * Kenneth * Excel Discussion (Misc queries) 1 March 30th 06 08:10 PM
Read Only - How to Cancel? Glenn Excel Discussion (Misc queries) 1 August 26th 05 06:23 PM
Cancel Message Howard Excel Discussion (Misc queries) 1 December 21st 04 05:31 PM


All times are GMT +1. The time now is 06:34 PM.

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

About Us

"It's about Microsoft Excel"