Display message before user can open spreadsheet

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Is there a way to display a message before a user can open
an Excel spreadsheet? A pop-up similar to providing a
password. I need to have a message that states, "By
opening this spreadsheet, you are agreeing to the terms
and conditions ...." The user would then click "ok"
before the spreadsheet would open. All help is
appreciated. Thanks.
 
Private Sub Workbook_Open()
MsgBox "Yada yada yada"
End Sub
Put that in the ThisWorkbook module in the VBA.
 
Back
Top