Change Sheet Names in Excel Macro Code

If you download one of the sample Excel workbooks from my Contextures website, you might want to customize it, to meet your requirements. The two videos below show how to customize one of my files, and you can make similar changes in other workbooks.

Excel Data Entry Form

These videos show how to make changes to the Worksheet Data Entry Form workbook.
It’s a popular download on my site, and people had questions about customizing it.

Customize the Worksheet Setup

The sample workbook has a sheet where you can enter data, and the first video shows how you can make changes to the worksheet setup.

For example, you might need to add another field with a drop down list of items.

Video: Customize Worksheet Setup

To see how to customize the worksheet setup in the sample file, watch this short video.

For written steps and screen shots, go to the Worksheet Data Entry page on my site.

Change Sheet Names in Code

Another thing that you might need to change, when you’re customizing one of the sample files, is the VBA code in the workbook.

In the Worksheet Data Entry file, if you change the sheet names, you’ll need to change the code, so Excel knows where to work its magic!

Two Options for Sheet Names

The video below shows 2 options for changing the sheet names in the code.

Change the sheet tab names in the code, with find and replace
Use sheet code names, instead of sheet tab names, for a better solution to the problem

You can apply the same techniques in other Excel VBA code, if you’re customizing a workbook for your own use.

Video: Change Sheet Names in Code

To see the steps for changing the sheet names in the code, watch this short Excel video tutorial.

For written steps and screen shots, go to the Worksheet Data Entry page on my site.

NOTE: The video timeline is below the video

Video Timeline

0:00 Intro
0:59 View the Code
2:10 Two Options
2:58 Find and Replace
4:55 Use Code Names
7:26 Get the Workbook

Get the Worksheet Data Entry Form

The zipped sample workbook can be downloaded from the Date Entry and Update form page on my Contextures site.

There are several versions of the worksheet data entry form, available for download. Check the descriptions, and get the file that most closely matches your requirements.

____________________