Hi all
I am using the following code within sub workbook_open ()
With Application
.Caption = "Store Paperwork"
.DisplayFormulaBar = False
.DisplayStatusBar = False
.DisplayScrollBars = False
.CommandBars("worksheet menu bar").Enabled = False
.CommandBars("chart menu bar").Enabled = False
.DisplayFullScreen = True
.CommandBars("full screen").Enabled = False
End With
With ActiveWorkbook
.Windows(1).Caption = Empty
.Windows(1).DisplayWorkbookTabs = False
.Windows(1).DisplayHeadings = False
.Windows(1).DisplayGridlines = False
and it works fine for a split second until a sheet is selected at the end of the procedure and then some of them turn themselves back on.
Anyone know why this is happening and how I can avoid it please? (this is really starting to bug me)
TIA
Dan.
I am using the following code within sub workbook_open ()
With Application
.Caption = "Store Paperwork"
.DisplayFormulaBar = False
.DisplayStatusBar = False
.DisplayScrollBars = False
.CommandBars("worksheet menu bar").Enabled = False
.CommandBars("chart menu bar").Enabled = False
.DisplayFullScreen = True
.CommandBars("full screen").Enabled = False
End With
With ActiveWorkbook
.Windows(1).Caption = Empty
.Windows(1).DisplayWorkbookTabs = False
.Windows(1).DisplayHeadings = False
.Windows(1).DisplayGridlines = False
and it works fine for a split second until a sheet is selected at the end of the procedure and then some of them turn themselves back on.
Anyone know why this is happening and how I can avoid it please? (this is really starting to bug me)
TIA
Dan.