Thanks for sending me the test.xls file. It appears to work as you intended.

However, my workbook still does not work correctly. You pointed out that I
can set a breakpoint inside the subroutine that should be executing, and run
the code step-by-step. This is true, but that's the ONLY way the code will
execute. If you remove all breakpoints and trigger the change event
normally, the SetOptionsToParetoAlternative won't do what it's supposed to do.

Thanks,

Jeffrey

""Peter Huang" [MSFT]" wrote:

Hi Jeff,

Based on my research, this problem has been fixed from Excel 2000.
Can you provide a simple reproduce xls file together with the test code?
So that we can try to reproduce at our side.

You can reach me via removing "online" from my email address.
Thanks!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.