| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying sheet code name and sheet name
Sub abc()
Dim sh as Worksheet For Each sh In ThisWorkbook.Worksheets s = "Tab Name " & sh.Name & vbNewLine _ & "Codename: " & sh.CodeName MsgBox s Next End Sub -- Regards, Tom Ogilvy "Barb Reinhardt" wrote: I have changed the code name for many of the sheets in my workbook, but want to get a listing of them. How are the code names and the sheet names coded so that I can display them? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Programmatically determining CODE NAME for sheet based upon Sheet | Excel Programming | |||
| VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
| How do i copy a active sheet to a new sheet with code and everything | Excel Programming | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
| unprotect sheet in code and make sheet visible | Excel Programming | |||
Threaded Mode
