View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_190_] ExcelMonkey[_190_] is offline
external usenet poster
 
Posts: 172
Default Status Bar Hangover

I have a routine that I have written that still has some
bugs in it. When it crashes, my status bar stays frozen
in the bottom left of the screen. I know to clear the
bar I would use:

Application.StatusBar = ""

There must be a way using error handling that says On
Error Application.StatusBar = "". Does anyone know how
exactly to do this. And where exactly can I put in my
code to trigger in case of any error whatsoever?

Thank-you.