Private Sub Workbook_SheetChange..issue

Hello all

having some trouble with my macro, as it doesnt appear to be working.

I have a macro in place that changes the worksheet name based on the entry in cell E5.

for some odd reason, after i re-opened the file, it stopped working. i have the workbook protected thru a password (u can run the password to unprotect sheet). but can someone pls let me know why the workbook is not updating the worksheet name when i change the entries in cell E5?

I have the following formula in "this workbook"

Please Login or Register  to view this content.

can someone pls advise..thx u

The cell you're changing is D5, not E5.

D5 contains i.e. the name, but E5 contains another part

i.e. D5 = John Doe
E5 = D5&" Performance"

so that is why i have it linked to E5, but its not changing it for some reason...ur thoughts?

basically, it changes, but....i need to go into the cell E5 and press enter. it does not automatically change, is there a way to make that work, for the macro to auto refresh?

E5 contains a formula which is what you want the sheet to be called, but D5 is the cell being changed, so it's when Target holds a reference to D5 that you want the worksheet name to change.

Using your current code as a basis:

Please Login or Register  to view this content.