| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation note to comment note | Excel Discussion (Misc queries) | |||
| Adding a note/comment | Excel Discussion (Misc queries) | |||
| save spreadsheet as note pad | Excel Discussion (Misc queries) | |||
| How to display 5.5 hours instead of 5.30 when adding \ subtracting | Excel Discussion (Misc queries) | |||
| Adding video to a spreadsheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
