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.
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”.
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
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...