Forum Discussion
Tullyk
Feb 24, 2019Copper Contributor
how to create pop up message very time workbook is opened
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. is there a way to do this? thanks kelly
FlyersKat1113
Feb 12, 2024Copper Contributor
Damien_Rosario thank you so much for this! Is there a way to create a two line message? For example to say:
EXCEPTIONS TEAM - please right-click and paste content as values.
ALL TEAMS: please do NOT alter Conditional Formatting options of this sheet.
When I tried hitting “enter” in VBA, it threw an error code.
TIA!!
HansVogelaar
Feb 12, 2024MVP
Like this:
Private Sub Workbook_Open()
MsgBox "EXCEPTIONS TEAM: please right-click and paste content as values" & vbCrLf & _
"ALL TEAMS: please do NOT alter Conditional Formatting options of this sheet."
End Sub
- FlyersKat1113Feb 12, 2024Copper ContributorThank you!