Adding a note and having it display on a spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
That worked really well but is there a way to get rid of the "Macros contain
viruses" notice option?
 
If this is for you macro security can be set to low under
tools>macro>security (I wouldn't recommend it though). if not for you it is
up to the users, if they have it set to high it will not run at all


--


Regards,


Peo Sjoblom
 
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.
 
Back
Top