Adding a note and having it display on a spreadsheet
Look in help for "digital certificate"
--
Regards,
Peo Sjoblom
"Dennis1188" wrote in message
...
I almost got it... Is it a big deal to sign the macro like you have done?
"Barb Reinhardt" wrote:
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?
|