Popup message opening excel file !

**janger** · 01-28-2012, 05:57 AM

I am familiar with the basic popup message when you open a excel file, however, if I want the message to only be displayed once when opened by a new user, how would I go about that ?

Thanks

JJ

**pike** · 01-28-2012, 06:13 AM

one way

Option Explicit

Private Sub Workbook_Open()
If Worksheet("Sheets1").Range("Z1000").Value = "" Then
MsgBox "Hello"
Worksheet("Sheets1").Range("Z1000").Value = "."
ThisWorkbook.Save = True
End If
End Sub

Thread: Popup message opening excel file !

Thread Tools

Display

Popup message opening excel file !

Re: Popup message opening excel file !

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions