Code to do Save as a specific cell value anytime the sheet is changed

Hi,

You already have in your file appropriate procedure in ThisWorkbook

Please Login or Register  to view this content.

But as one can see, at the end of it (after first saving) you switch off Events
I don't think you restore it elsewhere, do you?
If not - the event handlers are disabled and nothing happens after next changes in the workbook.

so may be start with:

Please Login or Register  to view this content.

And in immediate window of the VBA editor write

Please Login or Register  to view this content.

And then try again how your file works

1) in some other pieces of code you are disabling events - I spotted it for instance in Worksheet_Change of your first sheet. (most probable cause of problem). But also in Workbook_BeforeClose - you close the workbook, but enableevents scope is application-wide so other workbooks you have open (or open now) have disabled events too.

2) as you have Workbook_SheetChange in ThisWorkbook code, you shall not try to double the same functionality in sheet codes.

I have not tested further, because you have hardcoded "D:\picking logs\" etc. in several places in the code.

Anyway: if the event does not trigger the procedure - first concern always is

Please Login or Register  to view this content.

(or 0)

If for some reason you write Application.enableevents = false in the code, always make sure, that few lines later (the sooner, the better) you enable it again by

Please Login or Register  to view this content.