View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_21_] Stuart[_21_] is offline
external usenet poster
 
Posts: 154
Default 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.