Create pop-up photo when first opening workbook

[SaraWitch]

Hello peeps,

This is a bit random, but I just wondered if there is a way of having a photo pop-up when first opening an excel workbook, much like a pop-up message box...?

 

[eiloken]

Hello peeps,

This is a bit random, but I just wondered if there is a way of having a photo pop-up when first opening an excel workbook, much like a pop-up message box...?

something like this?

Private Sub Workbook_Open()
    If Sheet1.Cells(1, 1).Value = 0 Then
        'show popup form
        Sheet1.Cells(1, 1).Value = 1
    End If
End Sub

with open event of workbook, if cells(1,1)=0 then first time open and show form