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
HansVogelaar
MVP
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
FlyersKat1113
Feb 12, 2024Copper Contributor
Thank you!