Workbook_BeforeClose - Cancel not working
 

Hi

(XL2000)
Something very strange. I've programmed a BeforeClose event procedure
to check data and prevent the workbook from closing if the data's
wrong. I'm sure it worked until today. Now it doesn't. It clearly
shows that data is incorrect, but then the "Save changes to .....XLS?"
box comes up, and unless I click Cancel, the workbook closes!

I've found a possible solution to this, and I'm posting it here FYI -
but would welcome any comments or confirmation from anyone out there.
I've got TWO Excels: one on my machine, which I use for development,
and one on a Citrix box (urrghhh! can't control any of the
settings...).

Now my local machine's Excel is version 9.0.2720.
The Citrix version number is 9.0.6926 SP-3.

It's the Citrix version (the _more_ recent version) that's causing the
problem.

Is this a known issue that appeared in SP3, or is there some "ignore
anything clever the VBA programmer does" setting somewhere that's
enabled in the Citrix version? I can't find anything in the Options -
or in the MS KB.

cheers


Seb