Adding a note and having it display on a spreadsheet
 

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

Adding a note and having it display on a spreadsheet
 

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?

Adding a note and having it display on a spreadsheet
 

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?

Adding a note and having it display on a spreadsheet
 

If this is for you macro security can be set to low under
toolsmacrosecurity (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



"Dennis1188" wrote in message
...
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?

Adding a note and having it display on a spreadsheet
 

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?

Adding a note and having it display on a spreadsheet
 

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?

Adding a note and having it display on a spreadsheet
 

Here some info on it.

http://office.microsoft.com/en-us/he...495551033.aspx
--
HTH,
Barb Reinhardt



"Dennis1188" wrote:

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?

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?