I think the email (MS Outlook) asks once and allows vba code for ten minutes... after that it will ask again.


So essentially the fairly decent (if old) solution is slated to be removed and the BM wants it all in excel cause he can change as required...

Option to use Access?
At least you can keep a relational database using it. Maybe a VB front end..?

I'm not comfortable with the
"trusted" the data in DB as he felt he couldn't directly change and monitor it.
that statement could be very worrying


I hope you find a solution that works for you n BM