Display a text box about information using a macro each time the excel report opens

The text box is useful to give some information and/or instructions to some people so they can’t skip the message and so no choice than to read it when they open the excel file.

formula excel formula excel

 

When I use the macro ?

When I need to display a message for people each time they open the report.

 

How to create the macro ?

Read How to create, edit, hide and select a macro in an excel report

 

How to create the button to associate it with the macro ?

Read How to create a button and associated it to a macro in an excel report

 

How to use the macro ?

No way to use a customized name, it should be “Workbook_Open” and it is mandatory to put it inside “ThisWorkbook”.

formula excel

 

How is the macro ?

Copy the code below and paste it into your macro. You will see my comments in green if exist so follow the help to adapt to your need.

In one single line:

Sub Workbook_Open()
' change the content
MsgBox ("Be aware:1. To not do silly thing and 2. To follow the rules. Thanks")
End Sub

In 4 lines:

Sub Workbook_Open()
' change the content
MsgBox ("Be aware:" & vbNewLine & "1. To not do silly thing and" & vbNewLine & "2. To follow the rules." & vbNewLine & "Thanks")
End Sub

Interesting Management