View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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?