Status Bar Message
On Sep 3, 5:59*pm, RyanH wrote:
The macro must be changing the Application.StatusBar Property. *Maybe the
code looks something like this
Sub YourCode()
Application.StatusBar = "table:1"
* *'some code
Applicaiton.StatusBar = "table:2"
* *'some more code
Application.StatusBar = False
End Sub
Make sure that you set the Status Bar = False at the end of the Procedure to
give control back to Excel like I did in the example. *Else the Status Bar
will be stuck on "table:3"
--
Cheers,
Ryan
" wrote:
After running a simple macro on a worksheet, the status bar reads
"table:1" then "table:2" and finally "table:3". *I've never seen this
before. *Why is excel displaying these messages?
Thanks- Hide quoted text -
- Show quoted text -
There is nothing in the code that references the Status Bar.
|