I have a spreadsheet stored in a SharePoint site. I want to add a button to the top of the spreadsheet that the originator can click when the checklist has been saved in the Sharepoint folder (alerting users it's ready to use).
I am not sure where to start to write VBA that will send a notification email to a few addresses when a button is clicked.
The suggested links don't seem to be what I'm looking for -- I do not need to send the spreadsheet itself, just a memo stating it is saved and available.
Can anyone help?