Adding a note and having it display on a spreadsheet

D

Dennis1188

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

Barb Reinhardt

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
 
D

Dennis1188

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

Peo Sjoblom

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
 
B

Barb Reinhardt

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.
 
Top