View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
kiat kiat is offline
external usenet poster
 
Posts: 34
Default Renaming within VBA

I wonder if you are refering to the CodeName of a worksheet. This property
can only be set during design time in the worksheet's properties window.

"Brent McIntyre" wrote in message
...
Good evening all,

I was wondering if anyone knows how to programmatically
set the (Name) of objects such as Worksheets, renaming
them, ie setting the displayed name that you see when you
look at the worksheet is easy, but to reset the actual
object name I have been unable to achieve.

Any help that you may be able to provide would be much
appreciated.

Yours sincerely,

Brent McIntyre