how to create pop up message very time workbook is opened

Question

Hi, i am wanting to create a pop up message every time my work book is opened, to tell every one to read the "instructions" sheet before editing.&nbsp;is there a way to do this?thanks kelly

hansvogelaar · Answer

FlyersKat1113&nbsp;
Like this:
Private Sub Workbook_Open()
    MsgBox "EXCEPTIONS TEAM: please right-click and paste content as values" &amp; vbCrLf &amp; _
        "ALL TEAMS: please do NOT alter Conditional Formatting options of this sheet."
End Sub

damien_rosario · Answer

Hi&nbsp;Tullyk&nbsp;&nbsp;You could addin a simple message box that appears when you open the workbook.&nbsp;1. Add the Developer tab to your tab menu (right click onto a tab &gt; Customize the Ribbon and tick Developer).&nbsp;2. Go to Developer tab and click onto Visual Basic.&nbsp;3. In the left side list under VBAProject (Book1), double click ThisWorkbook.&nbsp;4. Drop down the list box where it says (General) and choose Workbook.&nbsp;5. Type in msgbox("your message").&nbsp;&nbsp;6. Save As a Excel Macro-Enbaled Workbook (*.xlsm).&nbsp;&nbsp;When you open the file, you will see a yellow warning pop up the top to enable macro content. Clicking Enable will then all the code to run.&nbsp;7. If you want the message to appear without this prompt, you could turn it off in File &gt; Options &gt; Trust Center &gt; Macro Settings &gt; Enable all macros...&nbsp;Just note there are some security risks doing this as malicious code could be executed if you happen to open a dodgy file.&nbsp;Anyway hope that helps?&nbsp;CheersDamien

flyerskat1113 · Answer

Damien_Rosario&nbsp;thank you so much for this! Is there a way to create a two line message? For example to say:&nbsp;EXCEPTIONS TEAM - please right-click and paste content as values.&nbsp;ALL TEAMS: please do NOT alter Conditional Formatting options of this sheet.&nbsp;When I tried hitting “enter” in VBA, it threw an error code.&nbsp;TIA!!

flyerskat1113 · Answer

Thank you!

Forum Discussion

how to create pop up message very time workbook is opened

Share

Resources