Thread: Sheet Codenames
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Annie Whitley Annie Whitley is offline
external usenet poster
 
Posts: 8
Default Sheet Codenames

Hi everyone,

I've got a workbook in which other users may rename sheets so I want to
change all tab names to codenames in VBA modules.

I've read that I can do it using Find/Replace in the VBE but what I wanted
to know is whether I need to tell it I'm using the codename for sheets.

If I have to (or should) how would I do it?
--
Thank you
Annie