VBA macro will only run once. Help please!

[Tayles]

Hello there,

I'm using the following code to rename the worksheets based on cell data:

Please Login or Register  to view this content.

I've linked this to a button on Sheet 1, which will run the code and rename the sheets. However, it only works once. After that, I have to save or exit for the code to run again. What am I doing wrong?

Thanks.

[GC Excel]

Hi and welcome to the forum.


Your code works for me.

[Tayles]

Hello there. It's works for me, too, but only once. If I change the cell data, then press the button to run the code again, nothing happens. I have to either save the file or close and reopen for it to work again. Any ideas? Could it be my Excel settings, rather than anything missing from the code?

[Arkadi]

Can you post your workbook Tayles? What you describe sounds strange, and I can get it to run multiple times on my end without issue.

[TMS]

Works fine, as many times as you want.


Regards, TMS

[Tayles]

Well now it's working for me! Didn't change anything, but out of the blue it started working. Very strange. Sorry for wasting your time.

[TMS]

No problem, it happens.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[Arkadi]

No worries, glad it worked out