On my Excel sheet I have been able to hide the command bars, tabs etc. - all, EXCEPT the 'bar' holding the Name Box and Formula Box - I have worked out they dont form a 'command bar' but simply can't discover how to turn them off?
I would be immensely grateful if anyone could enlighten me please....  

to hide the Formula Bar...

Application.DisplayFormulaBar = False

____________________________
Eggheads unite! You have nothing to lose but your yolks.

forget to mention...

quote:

---

remember...it's always polite to return all the command bars, formula bar, status bar, popup menus, etc. to the users' original settings after your Excel sheet exits...

---

IF there weren't users there wouldn't be commerce and money.

____________________________
We have a Mustek 5 M/Pix GSm@rt USB Digital Camera
for just £74.03 , offer only on until 30th February!

<AllDuck.com>      

Enquiries/Sales: 0845 430 9862
Fax: 0870 950 4532

In the words of Homer Simpson - "Doh!"
:-)

Thank you so much folks.

I plan to attach a macro to my exit button to restore the settings - just hope they exit that way and not in some bizarre fashion!

KRs

Jim

no problem...and hey...the best way to catch the user leaving your program is probably to put your clean up code in an Auto_Close sub (this will run when the (excel) file is closed)....like so...

Sub Auto_Close()     'Set Formula Bar to Original Setting     'Set Status Bar to Original Setting     'Set Menu Bars to Original Setting     'Set PopUp Bars to Original Setting End Sub

____________________________
Eggheads unite! You have nothing to lose but your yolks.