Currently I am using the following in a spreadsheet we use for internal reviews.
Is there some language I can use to stop the popup appearing once a user changes the filename from "X" to the standard we use when storing on our server?
Thank you for your input, I really appreciate it.
Code:
Private Sub Workbook_Open()
MsgBox "Click OK, then please save with your file name before entering information onto the form", vbOKOnly + vbExclamation, "ATTENTION!!!"
End Sub
Is there some language I can use to stop the popup appearing once a user changes the filename from "X" to the standard we use when storing on our server?
Thank you for your input, I really appreciate it.