Restore/Disable Title Bar

jgoulart · Mar 25th, 2002, 12:36 PM

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 · Mar 25th, 2002, 03:18 PM

Try going to View>FullScreen.

Tom Schreiner · Mar 25th, 2002, 03:56 PM

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

Tom Schreiner · Mar 25th, 2002, 10:24 PM

I could not find anything?
Sorry
Tom

Yogi Anand · Mar 25th, 2002, 11:10 PM

Quote:

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 · Mar 25th, 2002, 11:52 PM

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 · Mar 26th, 2002, 10:33 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 12:36 PM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	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

Mar 25th, 2002, 03:18 PM	#2
Anonymuus New Member Join Date: Mar 2002 Posts: 3	Try going to View>FullScreen.

Mar 25th, 2002, 03:56 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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

Mar 25th, 2002, 10:24 PM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	I could not find anything? Sorry Tom

Mar 25th, 2002, 11:52 PM	#6
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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

Mar 26th, 2002, 10:33 AM	#7
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	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