View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sethdunayer@yahoo.com is offline
external usenet poster
 
Posts: 3
Default 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.