For the notifications issue, possibly useful link:

https://www.vbforums.com/showthread....l-notification

ON the Copy/Paste issue, can you copy from Excel and then paste into a different application?