Restore/Disable Title Bar

[jgoulart]

Through experimentation trying to disable and enable different commandbar functions I have disabled my title bar (I'm not even sure that is what it is called to tell you the truth. It is the blue bar at the top of excel that has the X to cancel). How can I reset or re-enable my title bar?

John

 

[Anonymuus]

Try going to View>FullScreen.

 

[Legacy 98055]

I didn't even know you could do that.
Maybe you just invented a new method?
We'll call it workbooks.jgoulart.titlebar.killer
Ha Ha
I'll search and see what I can find!
Tom

 

[Legacy 98055]

I could not find anything?
Sorry
Tom

 

[Yogi Anand]

On 2002-03-25 11:36, jgoulart wrote:
Through experimentation trying to disable and enable different commandbar functions I have disabled my title bar (I'm not even sure that is what it is called to tell you the truth. It is the blue bar at the top of excel that has the X to cancel). How can I reset or re-enable my title bar?

Hi jgoulart:
To elaborate the response by ANONYMOUS to your posting ...
You can have the TitleBar disappear when you go to VIEW|FULL_SCREEN -- it toggles between FULL_SCREEN and let us say the normal(maximized view)
So, go back and do VIEW|FULL_SCREEN again and you will be back in business

HTH
Please post back if it works for you ... otherwise explain a little further and let us take it from there
_________________
Yogi Anand
Edit: Deleted inactive web site reference from hard coded signature
This message was edited by Yogi Anand on 2003-01-19 15:14

 

[Dave Hawley]

Hi John

Do you mean the "Worsheet Menu Bar" if so just run this code:

Sub ComeBack()
Application.CommandBars("Worksheet Menu Bar").Enabled = True
End Sub

 

[jgoulart]

Thank you all. I appreciate all of your help. The VIEW|FULL_SCREEN worked. I feel like kind of an idiot because I couldn't figure that out on my own. Now I'm trying to figure out if I actually used a macro to put it in that condition or I did it manually.

John