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.

Change hardcode to ....?
 

Is ws.Codename = "Sheet1" Then

--
HTH

Bob Phillips

"Stuart" wrote in message
...
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.

Change hardcode to ....?
 

Sorry, that is If not Is

--
HTH

Bob Phillips

"Stuart" wrote in message
...
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.

Change hardcode to ....?
 

Got it, thanks.
Regards.

"Bob Phillips" wrote in message
...
Is ws.Codename = "Sheet1" Then

--
HTH

Bob Phillips

"Stuart" wrote in message
...
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.