Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
57
Views
Topic starter
Hi Phil,
As mentioned, I am trying to send an email based on dates within a 7 day period which activates when excel opens. The email script works fine when run on its own, but when I add the ‘Workbook_Open’ it stops working.
Please find workbook attached.
Many thanks
Posted : 01/11/2018 4:32 am
Hi Austin,
Event code must go in the container for the particular event you want. So for Workbook events the code must go in the ThisWorkbook module
Please have a look at this Workbook and Worksheet Events
I've moved the Workbook_Open() code into ThisWorkbook and added some example code - see attached. You just need to put in whatever code you need in there.
Regards
Phil
Posted : 01/11/2018 7:30 am
