Forum

Hi Rafi, Use a Workbook_BeforeSave event Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) <<...

Hi Jenn, I've sent you an email. You could put the WB on Dropbox and link to it? Regards Phil

Jenn, Please supply your workbook. Regards Phil

Hi Sean, Just remove the reference to the sheet? =IF(INDEX(INPUTS!$H$4:$J$79,MATCH(F4,INPUTS!$H$4:$H$79,0),3)="""","""", INDEX(INPUTS!$H$4:$J$79...

Hi Sean, Please supply the workbook with the code/data. Regards Phil

Hi Sean, I don't really know what I am doing with this workbook. How exactly am I supposed to enter data into the Inventory Booked in Sheet? Usin...

Hi RS, Have you tried stepping through the code to see what it is doing? Debugging VBA Regards Phil

Hi Sean, Your VBA is password protected. Can't open it to debug it. Phil

Hi Steve, If there's nothing in the list you'll get this error. To check if there's nothing in the list you'll need to do something like If...

Hi Steve, Please supply your workbook and code. Too hard to debug without them. regards Phil

Hi Steven, It's always best to supply your workbook and code so we can see exactly what you are working with and give a better answer. Is the va...

Hi, Please see attached. The code for generating he email is taken from this post : VBA to create email and send with Outlook Regards Phil

Hi Lea, Insert (menu) -> Object -> Create from file (tab) -> Browse Insert an Object in Excel - Microsoft Regards Phil

OK so Q currently contains a date - you'll change this so it contains "expired" or some other text? What will the contents of the email be?

Hiya, Yes, changing a cell value would trigger an event that would then run the VBA to send the email. In order to do this I'd need to know what...