I would like to create a macro that would bring up an input box or preferably a list box that will allow me to input information for a sheet/tab name where where "TBL NPL NGRPL" appears in the code at the end of this message. The macro needs to be available to any new file created
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
The only worksheet names needed are below. <o
></o
>
<o
></o
>
TBL NPL NGRPL<o
></o
>
TBL NPL NIAU7<o
></o
>
TBL NPL NIAU8<o
></o
>
TBL NPL NIA10<o
></o
>
TBL NPL NNDU4<o
></o
>
This is the extent of my ability:
Sub Macro1()
Sheets("Sheet1").Select
Sheets("Sheet1").Name = "TBL NPL NGRPL"
Range("A1").Select
End Sub<o
></o
>
<o
></o
>
<o
></o
>
<o
>I created six macros, but there must be an easier way.</o
>
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




The only worksheet names needed are below. <o


<o


TBL NPL NGRPL<o


TBL NPL NIAU7<o


TBL NPL NIAU8<o


TBL NPL NIA10<o


TBL NPL NNDU4<o


This is the extent of my ability:
Sub Macro1()
Sheets("Sheet1").Select
Sheets("Sheet1").Name = "TBL NPL NGRPL"
Range("A1").Select
End Sub<o


<o


<o


<o

