Interesting Crash

I just learned of this fun little demo. This works (or rather fails) In Excel 2000, but not in more recent versions.

Save and close any important workbooks. Insert a chart sheet in a workbook, add a shape (a simple rectangle is sufficient) to the chart sheet. Switch back to the worksheet, and run this code:

ActiveWorkbook.ResetColors

Jon

Confirmed, but I wouldn't call it interesting

Everything Jon says is interesting.

Mike -

Damn straight. Could you come tell my kids that?

Thanks.

This one is als a Interesting crash in Excel 2002 to sum a cell in all worksheets

=SUM('*'!A20)

Where the '*' automatically converts to all sheets other than the activate one.
WARNING: Not working in Excel 2002, it crashes the application.

If your workbook have 6 sheets and you enter this formula in sheet3 the formula looks like this.
=SUM(Sheet1:Sheet2!A20,Sheet4:Sheet6!A20)

It was me that post this (I was not signed in)