Chip Pearson has a bunch of notes for application events at:

http://www.cpearson.com/excel/AppEvent.htm

At the bottom of that page, there's a link to download a sample workbook. Don't
miss that.

Personally, I never hide the statusbar. (I would find the message box very
irritating when calculation is set to automatic and I'm changing formulas.)



augustus wrote:

Hi,

I don't know anything about class module, but I think I know what I want to
do will need to be done in class module since it is an Application level
function.

I want to show a MsgBox whenever Application.CalculationState < xlDone, so
that user of the spreadsheet is aware of the calculation state. Since most
people hide the status bar to increase view area.

Thanks
Augustus

--

Dave Peterson