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
Bookmarks