[/B]Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim dWidth As Double
Dim dHeight As Double
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
Application.DisplayFormulaBar = True
Application.DisplayStatusBar = True
ActiveWindow.DisplayWorkbookTabs = True
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.DisplayVerticalScrollBar = True
dWidth = ActiveWindow.Width
dHeight = ActiveWindow.Height
'=======LOADING SCREEN=============='
'Home Monitor '792 height '1452 width
If dHeight = 792 And dWidth = 1452 Then
ActiveWindow.Zoom = 106
'Desktops '792 height '1452 width
ElseIf dHeight = 769.5 And dWidth = 1272 Then
ActiveWindow.Zoom = 100
Else
'Use Standard Default View Zoom
ActiveWindow.Zoom = 106
End If
Application.ScreenUpdating = True
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Application.ScreenUpdating = False
Dim dWidth As Double
Dim dHeight As Double
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
Application.DisplayFormulaBar = True
Application.DisplayStatusBar = True
ActiveWindow.DisplayWorkbookTabs = True
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.DisplayVerticalScrollBar = True
Worksheets("Home").Visible = True
Application.GoTo Sheets("HOME").Range("A1"), Scroll:=True
Set ws = Sheets("HOME")
Set shp = ws.Shapes("GROWBAR")
shp.Width = 0
dWidth = ActiveWindow.Width
dHeight = ActiveWindow.Height
'=======LOADING SCREEN=============='
'Home Monitor '792 height '1452 width
If dHeight = 792 And dWidth = 1452 Then
ActiveWindow.Zoom = 106
'Desktops '792 height '1452 width
ElseIf dHeight = 769.5 And dWidth = 1272 Then
ActiveWindow.Zoom = 100
Else
'Use Standard Default View Zoom
ActiveWindow.Zoom = 106
End If
Application.ScreenUpdating = True
End Sub
Private Sub Workbook_Open()
Dim dWidth As Double
Dim dHeight As Double
Set ws = Sheets("HOME")
'Application.Goto Worksheets("HOME").Range("A1"), Scroll:=True
ActiveWindow.WindowState = xlMaximized
Application.EnableCancelKey = xlDisabled
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
Application.DisplayFormulaBar = False
Application.DisplayStatusBar = Not Application.DisplayStatusBar
ActiveWindow.DisplayWorkbookTabs = False
ActiveWindow.DisplayHorizontalScrollBar = False
ActiveWindow.DisplayVerticalScrollBar = False
dWidth = ActiveWindow.Width
dHeight = ActiveWindow.Height
'=======LOADING SCREEN=============='
'Home Monitor '792 height '1452 width
If dHeight = 792 And dWidth = 1452 Then
ActiveWindow.Zoom = 106
'Desktops '792 height '1452 width
ElseIf dHeight = 769.5 And dWidth = 1272 Then
ActiveWindow.Zoom = 100
Else
'Use Standard Default View Zoom
ActiveWindow.Zoom = 106
End If
Application.ScreenUpdating = True
End Sub