Hi--

  I am trying to change the codename of a worksheet using the following code:

  myWorkbook.VBProject.VBComponents(oldSheetName).Na me = NewCodeName

This works fine in excel 2000 but it fails in excel2003 - VBProject is no longer an object of a workbook.

  How do I change the codename of a sheet in excel2003?

Thanks,

Barry:)

Hi Barry

You must set your VBProject to trusted.
Tools-Macro-Security-Trusted publishers tab -Trust access to Visual Basic Project

-vemaju