00:00In my recent video, I demonstrated how you can change the cell value when you rename
00:03your worksheet, but there were a lot of questions around how you can do the same thing the other
00:09way around.
00:10That is, is there a way to change the tab name or the worksheet name using the cell
00:16value?
00:17The answer to that is a big, astounding yes.
00:21Yes, you can.
00:22And here's how you do it.
00:23First, you're going to press alternate F11 to open your VBA editor.
00:27And after that, you're going to paste this VBA subroutine.
00:30If you like a copy of this VBA subroutine, please do leave a request on the comment section
00:35and I'll show you how you can get it.
00:37After that, press Ctrl S to save and then close your VBA editor like this.
00:42Now anytime you make a change like this weekly time sheet on your worksheet, you can see that
00:50your worksheet name gets updated as well.
00:57Okay, thank you very much, sir.
00:58for taking notes of your겐, sud my容.
00:59You
Comments