Change hardcode to ....?

I do not wish to stop a user changing the tab name of a particular sheet,
but if they do, then I need to keep track of it.
Say the tabname is "Temp" and the codename is Sheet1, as an example, how
would I amend the following, please?

If ws.Name = "Temp" Then

Regards.

Is ws.Codename = "Sheet1" Then

--
HTH

Bob Phillips

"Stuart" <sgbooth@totalise.co.uk> wrote in message
news:%23hRZ6AaTFHA.2392@TK2MSFTNGP10.phx.gbl...
> I do not wish to stop a user changing the tab name of a particular sheet,
> but if they do, then I need to keep track of it.
> Say the tabname is "Temp" and the codename is Sheet1, as an example, how
> would I amend the following, please?
>
> If ws.Name = "Temp" Then
>
> Regards.
>
>

Sorry, that is If not Is

--
HTH

Bob Phillips

"Stuart" <sgbooth@totalise.co.uk> wrote in message
news:%23hRZ6AaTFHA.2392@TK2MSFTNGP10.phx.gbl...
> I do not wish to stop a user changing the tab name of a particular sheet,
> but if they do, then I need to keep track of it.
> Say the tabname is "Temp" and the codename is Sheet1, as an example, how
> would I amend the following, please?
>
> If ws.Name = "Temp" Then
>
> Regards.
>
>

Got it, thanks.
Regards.

"Bob Phillips" <phillips@tiscali.co.uk> wrote in message
news:uvTMgJaTFHA.2568@TK2MSFTNGP10.phx.gbl...
> Is ws.Codename = "Sheet1" Then
>
> --
> HTH
>
> Bob Phillips
>
> "Stuart" <sgbooth@totalise.co.uk> wrote in message
> news:%23hRZ6AaTFHA.2392@TK2MSFTNGP10.phx.gbl...
>> I do not wish to stop a user changing the tab name of a particular sheet,
>> but if they do, then I need to keep track of it.
>> Say the tabname is "Temp" and the codename is Sheet1, as an example, how
>> would I amend the following, please?
>>
>> If ws.Name = "Temp" Then
>>
>> Regards.
>>
>>
>
>