With Application
.DisplayFormulaBar = False
.DisplayStatusBar = False
End With

and reverse

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"arunjoshi " wrote in message
...
i now know how to use a macro to remove all toolbars, and then get them
back again as they were originally.

how can i do the same with the formula bar and the status bar?


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