PDA

View Full Version : Solved: How To Re-edit The Sheet Names In VBE Project Window?



Erdin? E. Ka
06-12-2007, 08:09 AM
:hi: Hi everyone,

I want to rename the names of sheets. But not on workbook, in VBE project Window.

For example:

I have 15 worksheets in a workbook. I have to delete and add 11 sheets per my code runnung. So in VBE project window, the sheet names are getting larging...

I want that in VBE window, the sheet names are could be regular as:

( Sayfa = Sheet in Turkish. I have 2007 Turkish Edit.)

Sayfa1 (Starpark)
Sayfa2 (?ARPIŞAN)
Sayfa3 (TREN)
Sayfa4 (HAVA TOPU)
...
Sayfa5 (Istatistik_Ozet_Tablosu)

An example in the picture...

Thanks in advance...

Bob Phillips
06-12-2007, 08:15 AM
Dim sh As Worksheet
Dim i As Long
For Each sh In ThisWorkbook.Worksheets
i = i + 1
With sh
.Parent.VBProject.VBComponents(.CodeName) _
.Properties("_CodeName") = "Sayfa" & i
End With
Next sh

Erdin? E. Ka
06-12-2007, 08:22 AM
Hi Bob, it worked out well, thank you very much. :yes