Getting an error message to display if user forgets to rename worksheet

kwp004

Board Regular
Joined
Dec 27, 2016
Messages
91
I'm trying to make a macro that creates a new worksheet, based on a template sheet ("Default" below) and then hides that template sheet. The problem occurs if the user forgets to rename the new worksheet (and leaves it titled as "Insert Client Name") and then tries to rerun the macro.

How would I be able to get an error message to display if this occurs?

Sub CreateNewClient()


Sheets("Default").Visible = True
Sheets("Default").Select
Sheets("Default").Copy Before:=Sheets(2)
Sheets("Default (2)").Select
Sheets("Default (2)").Name = Insert Client Name"


Sheets("Default").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("Insert Client Name").Select


End Sub
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

ChuckDrago

Active Member
Joined
Sep 7, 2007
Messages
470
Office Version
  1. 2010
Platform
  1. Windows
Why don't you force the user to enter the client name using an inputbox, using a Do Until loop that tests for Sheets("Default (2)).Name <> "Insert Client Name"?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,493
Messages
5,601,998
Members
414,490
Latest member
Rip181

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top