Worksheet_Activate works differently in Excel 2007 and 2010

I created a very simple file to illustrate what I'm seeing. When I activate the BPC worksheet, it triggers the Worksheet_Activate event macro, which displays a message box "BPC". In Excel 2010, the content of the BPC worksheet is displayed before the message box is displayed. When I open the same file in Excel 2007 and activate the BPC worksheet, I get the message box, but the BPC worksheet is blank. Only after I click the OK button on the message box does the content on the BPC worksheet appear.

Also, I have conditional formatting using a UDF "ShowF" on cells B1:B4. In Excel 2007, after I click OK on the message box, the cell B2 flashes (the background goes from white to black and the text from black to white). When I click the Conditional Formatting button in the Styles area, the flashing stops. The flashing only occurs with conditional formatting that uses the UDF; with other conditional formatting (cell=0, for example), this doesn't happen.

Any ideas?

Thanks,
Richard

flashing cell problem.xlsm

No Activate procedure in the spreadsheet that came in...

Tony

I sit corrected! The procedures are indeed where you said they would be

I've had problems with UDF, and I recall that setting Application.volatile=true helped a bit. If you can get rid of the hyperlinks, and add that line of code (to the start of the uDF), see if that helps.

Tony