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" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> Is ws.Codename = "Sheet1" Then
>
> --
> HTH
>
> Bob Phillips
>
> "Stuart" <[email protected]> wrote in message
> news:%[email protected]...
>> 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" <[email protected]> wrote in message
news:%[email protected]...
> 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.
>
>