View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Status Bar and Column/Row Headings Help

Application.StatusBar = "Making progress"

It is in Tools, Options, View.
If you want to to this in VBA, just record with the macro recorder and see
the code.

RBS

"PostalVote " wrote in message
...
Hi

I have two queries for which I cannot find. Can any one help?

1) I am trying to input a message in to the status bar while a macro is
running to let the user know that something is happening, but have no
idea how to do this.

2) I have seen worksheets with their column and row headers hidden or
removed. How is this done?


Any advise is very much appreciated.

Thanks in advance
Mike


---
Message posted from http://www.ExcelForum.com/