Display message before user can open spreadsheet

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.
 
T

Thomas

Private Sub Workbook_Open()
MsgBox "Yada yada yada"
End Sub
Put that in the ThisWorkbook module in the VBA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Excel freezing after sharing document by Email 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Creating a Chart on form from selected data in query. 0
Office 365 Email Encryption One time Passcode 0
Integrating information from Word to Excel (not mail merge) 1
Active Content in this file is blocked issue 1
Spreadsheet Security 1

Top