- In data validations, if you want to display a message make sure you have a title otherwise it will display null at the front of the message
- If you have action buttons that navigate between sheets and leave the workbook name blank then the navigation will work but the workbook name will be lost from the tab bar. You can set the workbook name to be a named range if this is an issue
- In the action button process options, don’t delete the messages, only untick them to not display anything