ExcelBanter - Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel 2007 (https://www.excelbanter.com/excel-programming/431941-excel-2007-a.html)

Can anyone help me to hide the title-bar in a workbook by means of code in
Excel 2007?

TWG;439436 Wrote:
Can anyone help me to hide the title-bar in a workbook by means of code
in
Excel 2007?
What is it you mean by "Title Bar"? do you mean the bar that displays
"Book1 - Microsoft Excel"?

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121919

Yes

Simon Lloyd skrev:

TWG;439436 Wrote:
Can anyone help me to hide the title-bar in a workbook by means of code
in
Excel 2007?
What is it you mean by "Title Bar"? do you mean the bar that displays
"Book1 - Microsoft Excel"?

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121919

The only way to do this is to use full screen:

Code:
--------------------
Private Sub Workbook_Activate()
Application.DisplayFullScreen = False
End Sub

Private Sub Workbook_Deactivate()
Application.DisplayFullScreen = True
End Sub

--------------------

*How to Save a Workbook Event Macro*
1. *Copy* the macro using *CTRL+C* keys.
2. Open your Workbook and *Right Click* on any *Worksheet's Name Tab*
3. *Left Click* on *View Code* in the pop up menu.
4. Press *ALT+F11* keys to open the *Visual Basic Editor.*
5. Press *CTRL+R* keys to shift the focus to the *Project Explorer
Window*
6. Press the *Down Arrow Key* until *ThisWorkbook* is highlighted in
blue.
7. *Press* the *Enter* key to move the cursor to the *Code Window*
8. *Paste* the macro code using *CTRL+V*
9. *Save* the macro in your Workbook using *CTRL+S*

TWG;440242 Wrote:
Yes

Simon Lloyd skrev:

TWG;439436 Wrote:
Can anyone help me to hide the title-bar in a workbook by means of
code
in
Excel 2007?
What is it you mean by "Title Bar"? do you mean the bar that displays
"Book1 - Microsoft Excel"?

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' ('http://www.thecodecage.com'
(http://www.thecodecage.com/))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Excel 2007 - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=121919)

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121919

As you can see, I already have this command in the workbooks AUTO_OPEN - thus:

Sub auto_open()
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayZeros = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
Application.DisplayFullScreen = True
End Sub

BUT - it does not make the title-bar invisuable

Simon Lloyd skrev:

The only way to do this is to use full screen:

Code:
--------------------
Private Sub Workbook_Activate()
Application.DisplayFullScreen = False
End Sub

Private Sub Workbook_Deactivate()
Application.DisplayFullScreen = True
End Sub

--------------------

*How to Save a Workbook Event Macro*
1. *Copy* the macro using *CTRL+C* keys.
2. Open your Workbook and *Right Click* on any *Worksheet's Name Tab*
3. *Left Click* on *View Code* in the pop up menu.
4. Press *ALT+F11* keys to open the *Visual Basic Editor.*
5. Press *CTRL+R* keys to shift the focus to the *Project Explorer
Window*
6. Press the *Down Arrow Key* until *ThisWorkbook* is highlighted in
blue.
7. *Press* the *Enter* key to move the cursor to the *Code Window*
8. *Paste* the macro code using *CTRL+V*
9. *Save* the macro in your Workbook using *CTRL+S*

TWG;440242 Wrote:
Yes

Simon Lloyd skrev:

TWG;439436 Wrote:
Can anyone help me to hide the title-bar in a workbook by means of
code
in
Excel 2007?
What is it you mean by "Title Bar"? do you mean the bar that displays
"Book1 - Microsoft Excel"?

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' ('http://www.thecodecage.com'
(http://www.thecodecage.com/))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Excel 2007 - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=121919)

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121919

Hmmm, you no longer need to use Auto_open since xl97 you can use Wthe
Workbook_Open event in the thisworkbook module, anyway did you at least
try it the way i supplied it?TWG;441276 Wrote:
As you can see, I already have this command in the workbooks AUTO_OPEN -
thus:

Sub auto_open()
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayZeros = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
Application.DisplayFullScreen = True
End Sub

BUT - it does not make the title-bar invisuable

Simon Lloyd skrev:

The only way to do this is to use full screen:

Code:
--------------------
Private Sub Workbook_Activate()
Application.DisplayFullScreen = False
End Sub

Private Sub Workbook_Deactivate()
Application.DisplayFullScreen = True
End Sub

--------------------

*How to Save a Workbook Event Macro*
1. *Copy* the macro using *CTRL+C* keys.
2. Open your Workbook and *Right Click* on any *Worksheet's Name Tab*
3. *Left Click* on *View Code* in the pop up menu.
4. Press *ALT+F11* keys to open the *Visual Basic Editor.*
5. Press *CTRL+R* keys to shift the focus to the *Project Explorer
Window*
6. Press the *Down Arrow Key* until *ThisWorkbook* is highlighted in
blue.
7. *Press* the *Enter* key to move the cursor to the *Code Window*
8. *Paste* the macro code using *CTRL+V*
9. *Save* the macro in your Workbook using *CTRL+S*

TWG;440242 Wrote:
Yes

Simon Lloyd skrev:

TWG;439436 Wrote:
Can anyone help me to hide the title-bar in a workbook by means
of
code
in
Excel 2007?
What is it you mean by "Title Bar"? do you mean the bar that
displays
"Book1 - Microsoft Excel"?

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' ('http://www.thecodecage.com'
('The Code Cage - Microsoft Office Help - Microsoft Office
Discussion' (http://www.thecodecage.com/)))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile:
Simon
Lloyd' ('The Code Cage Forums - View Profile: Simon Lloyd'
(http://www.thecodecage.com/forumz/member.php?userid=1))
View this thread: 'Excel 2007 - The Code Cage Forums'
('Excel 2007 - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh....php?t=121919))

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' ('The Code Cage - Microsoft Office Help -
Microsoft Office Discussion' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Excel 2007 - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=121919)

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121919

You are missing a few things.

Private Sub Auto_Open()
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
With Application
.DisplayStatusBar = False
.CommandBars("Worksheet Menu Bar").Enabled = False
.DisplayFullScreen = True
.DisplayFormulaBar = False
End With
End Sub

Don't forget to code to change reset when the workbook is closed.

Or you can use Thisworkbook Activate and Deactivate events as Simon points
out.

Gord Dibben MS Excel MVP

On Tue, 4 Aug 2009 11:18:03 -0700, TWG
wrote:

As you can see, I already have this command in the workbooks AUTO_OPEN - thus:

Sub auto_open()
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayZeros = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
Application.DisplayFullScreen = True
End Sub

BUT - it does not make the title-bar invisuable

Simon Lloyd skrev:

The only way to do this is to use full screen:

Code:
--------------------
Private Sub Workbook_Activate()
Application.DisplayFullScreen = False
End Sub

Private Sub Workbook_Deactivate()
Application.DisplayFullScreen = True
End Sub

--------------------

*How to Save a Workbook Event Macro*
1. *Copy* the macro using *CTRL+C* keys.
2. Open your Workbook and *Right Click* on any *Worksheet's Name Tab*
3. *Left Click* on *View Code* in the pop up menu.
4. Press *ALT+F11* keys to open the *Visual Basic Editor.*
5. Press *CTRL+R* keys to shift the focus to the *Project Explorer
Window*
6. Press the *Down Arrow Key* until *ThisWorkbook* is highlighted in
blue.
7. *Press* the *Enter* key to move the cursor to the *Code Window*
8. *Paste* the macro code using *CTRL+V*
9. *Save* the macro in your Workbook using *CTRL+S*

TWG;440242 Wrote:
Yes

Simon Lloyd skrev:

TWG;439436 Wrote:
Can anyone help me to hide the title-bar in a workbook by means of
code
in
Excel 2007?
What is it you mean by "Title Bar"? do you mean the bar that displays
"Book1 - Microsoft Excel"?

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' ('http://www.thecodecage.com'
(http://www.thecodecage.com/))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Excel 2007 - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=121919)

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121919

Yes, I tried. The title-bar is still visible

Simon Lloyd skrev:

Hmmm, you no longer need to use Auto_open since xl97 you can use Wthe
Workbook_Open event in the thisworkbook module, anyway did you at least
try it the way i supplied it?TWG;441276 Wrote:
As you can see, I already have this command in the workbooks AUTO_OPEN -
thus:

Sub auto_open()
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayZeros = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
Application.DisplayFullScreen = True
End Sub

BUT - it does not make the title-bar invisuable

Simon Lloyd skrev:

The only way to do this is to use full screen:

Code:
--------------------
Private Sub Workbook_Activate()
Application.DisplayFullScreen = False
End Sub

Private Sub Workbook_Deactivate()
Application.DisplayFullScreen = True
End Sub

--------------------

*How to Save a Workbook Event Macro*
1. *Copy* the macro using *CTRL+C* keys.
2. Open your Workbook and *Right Click* on any *Worksheet's Name Tab*
3. *Left Click* on *View Code* in the pop up menu.
4. Press *ALT+F11* keys to open the *Visual Basic Editor.*
5. Press *CTRL+R* keys to shift the focus to the *Project Explorer
Window*
6. Press the *Down Arrow Key* until *ThisWorkbook* is highlighted in
blue.
7. *Press* the *Enter* key to move the cursor to the *Code Window*
8. *Paste* the macro code using *CTRL+V*
9. *Save* the macro in your Workbook using *CTRL+S*

TWG;440242 Wrote:
Yes

Simon Lloyd skrev:

TWG;439436 Wrote:
Can anyone help me to hide the title-bar in a workbook by means
of
code
in
Excel 2007?
What is it you mean by "Title Bar"? do you mean the bar that
displays
"Book1 - Microsoft Excel"?

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' ('http://www.thecodecage.com'
('The Code Cage - Microsoft Office Help - Microsoft Office
Discussion' (http://www.thecodecage.com/)))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile:
Simon
Lloyd' ('The Code Cage Forums - View Profile: Simon Lloyd'
(http://www.thecodecage.com/forumz/member.php?userid=1))
View this thread: 'Excel 2007 - The Code Cage Forums'
('Excel 2007 - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh....php?t=121919))

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' ('The Code Cage - Microsoft Office Help -
Microsoft Office Discussion' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Excel 2007 - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=121919)

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121919