AW: Rechteck Vollbild anzeigen
14.12.2017 12:50:39
fcs
Hallo Peter,
ohne exessiven Programmieraufwand kannst du Excel im Vollbildmodus anzeigen und die Rechteckte so groß einstellen, dass sie den gesamten sichtbaren Zellbereich überdecken.
Viel Glück mit der folgenden Variante.
Gruß
Franz
Private Sub CommandButton3_Click()
Dim objShape As Shape
Dim dblH As Double, dblW As Double
Dim rngVisible As Range
Sheets(2).Activate
'einleitung,Bild anzeigen
Application.DisplayFullScreen = True
ActiveWindow.DisplayHeadings = False
With Sheets(2)
.Range("A1").Select
Set rngVisible = ActiveWindow.VisibleRange
With rngVisible
With .Cells(.Rows.Count, .Columns.Count)
dblH = .Top + .Height
dblW = .Left + .Width
End With
dblH = dblH - .Top
dblW = dblW - .Left
End With
Set objShape = .Shapes("Rechteck 1")
With objShape
.Left = rngVisible.Left
.Top = rngVisible.Top
.Width = dblW
.Height = dblH
End With
Set objShape = .Shapes("Rechteck 2")
With objShape
.Left = rngVisible.Left
.Top = rngVisible.Top
.Width = dblW
.Height = dblH
End With
.Shapes("Rechteck 2").Visible = False
.Shapes("Rechteck 1").Visible = True
.Shapes("Rechteck 1").Select
Application.ScreenUpdating = True
Application.ScreenUpdating = False
'hier kommt dann dein makro
Application.Wait (Now + TimeValue("0:00:01"))
'anzeige ,process ist beendet
.Activate
Application.ScreenUpdating = True
.Shapes("Rechteck 1").Visible = False
.Shapes("Rechteck 2").Visible = True
.Shapes("Rechteck 2").Select
Application.ScreenUpdating = True
Application.Wait (Now + TimeValue("0:00:02"))
.Shapes("Rechteck 2").Visible = False
End With
ActiveWindow.DisplayHeadings = True
Application.DisplayFullScreen = False
Sheets(1).Activate
End Sub