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

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?

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?

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



"Dennis1188" <(E-Mail Removed)> wrote in message
news:AC2B533B-E807-47C3-A822-(E-Mail Removed)...
> 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?

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?

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?

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?

Look in help for "digital certificate"


--


Regards,


Peo Sjoblom



"Dennis1188" <(E-Mail Removed)> wrote in message
news:8F3FB7C2-F893-4C62-B072-(E-Mail Removed)...
>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?