Adding a note and having it display on a spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
That worked really well but is there a way to get rid of the "Macros contain
viruses" notice option?
 
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
 
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.
 
I almost got it... Is it a big deal to sign the macro like you have done?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell shows the last typed text, no matter where it is typed 0
Excel 2003, Linked Spreadsheet, Cell Character Count 3
Turn off prompts 1
Issue is facing on Word 2016 -{EMBEDED Excel.Sheet.12} 0
Search OF Macros for a specific phrase 2
Clear a cell's contents when document is saved 2
Can I group multiple spreadsheets to make universal changes? 5
Highlight External Links 1

Back
Top