Hiding Tabs

B

beng120

I am creating an interactive catalogue in excel and to make it look a
lot neater i would like to know how i can hide the worksheet tabs,
numbers and letters at the sides and the toolbars so that when it is
opened by someone all they see is the catalogue itself and not the
toolbars etc... :confused:
 
P

Paul Sheppard

beng120 said:
I am creating an interactive catalogue in excel and to make it look a
lot neater i would like to know how i can hide the worksheet tabs,
numbers and letters at the sides and the toolbars so that when it is
opened by someone all they see is the catalogue itself and not the
toolbars etc... :confused:
Click to expand...

Hi beng120

To hide sheet tabs, row and column headers (numbers and letters at
sides, go to Tools > Options, select the view tab and uncheck the
features you dont want

To hide the toolbars go to View > Toolbars and click on the toolbars
that have a tick to remove them

Hope this helps

Paul
 
N

Norman Jones

Hi Beng120,

You can specify these settings on the Tools | Options | View tab.

If you want to automate the process, the following code will apply the
settings whenever the workbook is opened or activated and will reverse the
settings when another workbook is activated or when the workbook is closed.

'=====================>>
Option Explicit

Private Sub Workbook_Open()
With ActiveWindow
.DisplayHeadings = False
.DisplayWorkbookTabs = False
End With
Application.DisplayFullScreen = True
End Sub


Private Sub Workbook_WindowActivate(ByVal Wn As Window)
With ActiveWindow
.DisplayHeadings = False
.DisplayWorkbookTabs = False
End With
Application.DisplayFullScreen = True
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
With ActiveWindow
.DisplayHeadings = True
.DisplayWorkbookTabs = True
End With
Application.DisplayFullScreen = False
End Sub
Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
With ActiveWindow
.DisplayHeadings = True
.DisplayWorkbookTabs = True
End With
Application.DisplayFullScreen = False
End Sub
'<<======================


This is workbook event code and should be pasted into the workbook's
ThisWorkbook code module *not a standard module or a sheet module):

*****************************************************
Right-click the Excel icon on the worksheet
(or the icon to the left of the File menu if your workbook is maximised)

Select 'View Code' from the menu and paste the code.

Alt-F11 to return to Excel.
*****************************************************
 
B

british.assassi

I have tried this code to hide everything, but when excel is minimized
all the toolbars come back .... is there anyway to stop this?

TIA

british.assassin
 
Top