Change a worksheet_change to a workbook_change code

[sassriverrat]

I have a timestamp I've previously talked to people about. It's a worksheet_change item and I either need to make it into a macro that runs automatically (so when I input data into "R5" it puts a permanent, non-changing/updating timestamp "dd-mmm-yy" in "F4"

The fun part about this- it needs to add to sheets when the sheets are made- so I have a macro that creates a new sheet and formats the whole thing (talk about a long set of codes...). It also inserts all of the formulas into their respective cells. Now I need this timestamp to go in automatically when a new sheet is made and it can't just be a simple Now() as that would update each time the workbook is reopened.

Thanks!

 

[footoo]

Before amendment, if the line "If Not Intersect(Target, Range("R8,W25")) Is Nothing Then" does not get triggered, thenEnableEvents does not get set back to True.

 

[sassriverrat]

So the never ending fun.
Nearly finished with this project- this started producing errors again. It doesn’t want to .numberformat and says it can’t. Any ideas what might cause this?

 

[footoo]

What line of code and exactly what error message?

 

[sassriverrat]

I got it working. I had mistakenly locked the sheet using vba and forgotten to put UserInterfaceOnly:=True problem solved.

However- I do have a new, open thread on a topic along the same lines. The worksheet_change is always looping, correct?