The users can also choose not to run macros when they open the file. I
suppose you could sign the macros somehow so that the message wouldn't come
up. I've only done that with my own files because I'm tired of the message.
--
HTH,
Barb Reinhardt



"Dennis1188" wrote:

That worked really well but is there a way to get rid of the "Macros contain
viruses" notice option?

"Barb Reinhardt" wrote:

You could put something like this into your "ThisWorkbook" module.
Access the module with Alt F11, select the "ThisWorkbook" module and past
this in

Private Sub Workbook_Open()
MsgBox ("This is the message you want displayed")
End Sub

--
HTH,
Barb Reinhardt



"Dennis1188" wrote:

Is there a way to have a note display or pop-up each time a spreadsheet is
opened?